Read a .CSV file generated by LabView into Python

[rolfk]

Well that is the new Excel binary format. Basically it is a collection of XML files and other metainformation packed into a ZIP archive. I'm pretty sure there is some Python Library that sort of reads this file format too, but it is definitely not a simple text reader that you can use for this.

[MyBrotherJohn]

Looks like I have stumbled on the solution to the file format problem... and the reason why I couldn't upload my file at previous attempts. The file I finally managed to upload was the wrong one (.xlsx extension - a product of my playing about) so I tried to upload the correct version and I got this error from the site at the top:

The attachment's ch0_007 - copy.csv content type (application/vnd.ms-excel) does not match its file extension and has been removed.

Given the .xlsx (same contents) did upload it looks like it may simply be excel format. No ideas where the .csv came from.

Thanks once again for everyone's thoughts!

[MyBrotherJohn]

Yeah, openpyxl or pandas or anything should be able to do it, however it doesn't like the .csv extension and errors if it sees that in conjunction with an attempt to read a file in excel format.

I'll change the extension and see if it reads.

[MyBrotherJohn]

Final note: Errored with openpyxl but pandas read_excel worked.

Thanks once again for all the input.

[altenbach]

---

@MyBrotherJohn wrote:

The attachment's ch0_007 - copy.csv content type (application/vnd.ms-excel) does not match its file extension and has been removed.

Given the .xlsx (same contents) did upload it looks like it may simply be excel format. No ideas where the .csv came from.

---

The AV scanner of the site does deep file inspection and if your file extension does not match the contents, it will not be accepted. You can attach anything IF you place it in a zip file first, so that's the preferred way of attaching files anyway.

You should be able to attach a csv file if it really is one, but it seems it isn't.

I still would be curious to see the LabVIEW code that wrote the file.

[MyBrotherJohn]

I’ll try to get hold of it but I suspect the chances are pretty slim...