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++;
}
}
#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;
}