'LabVIEW generated Excel files unable to be read by pandas.read_excel
I'm having an issue when I save LabVIEW outputs as .xlsx files. When I try to import with Pandas I get the following error:
expected <class 'openpyxl.styles.fills.Fill'>
It seems LabVIEW uses unusual encoding or something.
One workaround that I've found is that if I just open the Excel file and save it, there's no problem reading with Pandas. Is there a simple way to automate opening an excel file in Python or R and saving it?
Thanks all!
Solution 1:[1]
Sorry,maybe, I can't understand your questions, you seems to whether you can open LabVIEW file and reload it. If I have meet this question, I will use python3 to decode. for example:
df = pd.read_excel(f'E:\\??????????\\11???????\\{name}')
If I have no understand your problems, it's my faults. Thanks for your reading.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | biao zhu |