![]() ![]() There are tricks to fasten it, like hiding Excel window, copying arrays of data instead of cell-by-cell approach and such. This is most easy and compatible method, though is noticeably slow due to COM IPC marshalling and switching. Each excel sheet has a random cells filled, some of those may constitute quazi-tabular ranges, or may not.ĭepending on the installed software you canġ) use Excel application to open XLSX, read the cells and pass them to your program. Has anyone got any ideas? Perhaps some code that could be used to prove what is wrong.ADO in Delphi is leaning to TDataSet model, which mean strictly tabular data. I have read that there are some DLL's that may be missing or inactive but have been assured by the sites IT company that they should all be in order. The failing installs are on a 64bit system, but I have successfully installed on other 64 bit systems. The process was developed in Delphi 7 on a 32bit system. Showmessages run on the customers site show the connection succeeding but the opening of the query (which works on every other installation I have tried) fails. On this one site I get the message 'Unable to read data from Excel, make sure the query is meaningful' ShowMessage('Unable to read data from Excel, make sure the query ' + edtSpreadsheet.Text + ShowMessage('Unable to connect to Excel, make sure the workbook ' + edtSpreadsheet.Text + ' exists!') 'Data Source=' + edtSpreadsheet.Text + ' ' + The procedures procedure TFormSpreadsheet.ConnectToExcel Up to a recent install on one customers site it works perfectly. I have a number of applications that read Excel spreadsheets for conversion to SQLĪll the applications are based on the same technique using the following procedures. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |