[QUESTION] Ingesting Excel Files

Open Likhitha075 opened this issue 1 year ago • 3 comments

Question

When I attempt to upload an Excel file, I encounter an encoding-related error. I've attached it for reference. How can I upload Excel files to privateGPT like I do with other files? Are any code changes necessary, considering that Llama supports PandasExcelReader as well?

Oct 28 '24 04:10 Likhitha075

Can you try to resaving in another encoding and reuploading? Using UTF-8 should work without any issue

Nov 04 '24 08:11 jaluma

I’ve tried using a different encoding format, but the issue persists. The error is as follows: 'UnicodeDecodeError: 'charmap' codec can't decode byte 0x8d in position 663: character maps to undefined'

Nov 04 '24 11:11 Likhitha075

Can you try to save using other format xlsx vs xls? It should work without problem. Are there any non-ascii char in the document?

Nov 11 '24 07:11 jaluma