I need to open an excel file, to read a certain sheet and to save it as csv on a server where MS Office is not installed. I know how to set the ADO properties so that to get data either as array (GetRows method) or as string using GetString method but when I try to save data on disk I have to wait over 10 seconds to see the file processed (4770 rows/43 columns). Besides this, for some reason some cells with a very large description text (2000-3000 characters) failed to be read/wrote properly in the csv file appearing as merged with the adjacent cells. In the same time, considering a small function written in python (via pandas library) and called with Shell command took approx.600-700 ms. I am a bit frustrated that I cannot reproduce in VB6 a procedure like this while in other languages it seems to be trivial.




Reply With Quote