vothaison
0
Q:

c++ excel blank cells

// Get Data
string itemPartNumber;
int itemQuantity;
int iLoop = 2; // Skip the column title
bool exitLoop = false;

ClearList(ref bomList);  //Clear my destination list

while (!exitLoop)
{
    var itemPn = xlsSheet.Cells[iLoop,1].Value2;
    var itemQu = xlsSheet.Cells[iLoop,2].Value2;

    exitLoop = (itemPn == null);
    if (!exitLoop)
    {
        itemPartNumber = (string) itemPn;
        itemQuantity = Int32.Parse(itemQu.ToString());
        ComponentPNQ itemList = new ComponentPNQ(itemPartNumber, itemQuantity);
        bomList.Add(itemList);
        iLoop++;
    }
}
0
#include <iostream>
#include <fstream>
#include <sstream>
#include <vector>

int main()
{
    std::fstream file("myfile.txt");
    std::vector<std::string> vec;

    if(file.is_open())
    {
        std::string line;
        bool Skip = true;

        while(std::getline(file, line))
        {
            std::stringstream sstr(line);
            std::string word;

            while (std::getline(sstr, word, ' '))
            {
                if(!word.empty())
                    vec.emplace_back(word);

                else if(word.empty() && Skip)
                {
                    vec.emplace_back("NaN");
                    Skip = false;
                }
            }
            Skip = true;
        }
        file.close();
    }

    for(size_t i = 0; i < vec.size(); ++i)
    {
        std::cout << vec[i] << " ";
        if((i+1)%3 ==0) std::cout << std::endl;
    }
    return 0;
}
0

New to Communities?

Join the community