How to copy data from excel?

Question

Delphi

There is a standard task to raise the Excel as ole Automation and read the data.

The problem is that the excel is very large. You need to copy the data from range into a two-dimensional ansistring array.
Walking through the cells in a cycle is very slow.
Is there any way to recopy the data in one fell swoop (only in string and not olevariant)
Well, like a copy-paste vyklenuyu area from Excel.

Answer 1

From free https://github.com/ms301/Excel4Delphi

Answer 2

the standard task is to raise the excel like ole automation and read the data

Can be used OLE DBbefore Delphi, in the intermediate layer. And work through TADOConnection.

Create udl file

Answer 3

You can use OLE to save the entire document or part of it in CSV format, and read it quickly