![]() ![]() btw I had to use backticks to enclose the name because using brackets like this gave out a syntax error message. I tried to read the cells one by one by issuing one query of the form SELECT F1 FROM `SheetName$A1:A1`īut now the driver returns an error saying "There is data outside the selected region". I need the sheet to be loaded "as is", ie know exactly from what cell position each value comes from. The returned results do not contain the empty rows or empty columns, so if the sheet contains such rows or columns, the following cells are shifted and do not end up in their correct position. My problem then is that when I use the following query: SELECT * FROM ![]() Provider=.12.0 Data Source=file.xlsx Extended Properties="Excel 12.0 Persist Security Info=False IMEX=1 HDR=No" I connect using either Provider=.4.0 Data Source=file.xls Extended Properties="Excel 8.0 Persist Security Info=False IMEX=1 HDR=No" When possible I use automation to read the cells one by one, but when Excel is not installed, I revert to using the ADO/ODBC Jet driver. I'm trying to read an Excel sheet from an XLS or XLSX file in memory using Delphi 7. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |