parsing an xlsx

CorText Manager Q&A forum › Category: Data processing › parsing an xlsx
0 Vote Up Vote Down
Jacopo asked 2 months ago

I am trying to parse an xlsx file. I follow this procedure: it is uploaded in a .zip format, the data within columns are separated by *** and I’m indicating the column with date in year format. However, it keeps saying that the dataset is corrupted or it doesn’t contain any table (different mistakes that I received different times trying to upload the same dataset…). 
Could someone help? 
Thanks

7 Answers
0 Vote Up Vote Down
Jacopo answered 2 months ago

I have also tried to upload it in csv format, but I get the same problem. I tried your csv sample and tried to upload it both in csv and in excel, but it doesn’t work either. So I guess it is not an issue of data formata, but I must be doing something wrong in the parsing phase. 

0 Vote Up Vote Down
Jacopo answered 2 months ago

I have also tried to upload it in csv format, but I get the same problem. I tried your csv sample and tried to upload it both in csv and in excel, but it doesn’t work either. So I guess it is not an issue of data formata, but I must be doing something wrong in the parsing phase. 

0 Vote Up Vote Down
Lionel Staff answered 2 months ago

Dear Jacopo,
This is indeed interesting! Let’s check it out

0 Vote Up Vote Down
Lionel Staff answered 2 months ago

For the example, are you referring to this page and this csv file?
I just tried the csv file, zipped it, uploaded it and used the robust csv parsing option. And it worked without a problem.

0 Vote Up Vote Down
Lionel Staff answered 2 months ago

So, I have opened the csv example in ms excel and :

  • saved it in .xls
  • saved it in .xlsx
  • zipped the .xls
  • zipped the .xlsx
  • and tried both in Cortext Manager, with the xls option of the parsing script and I got my two datasets in my project.

It worked like a charm.

1 2 Next »