Re: Win32::OLE Excel temporary objects destruction

One more thought: could you write the data to a temporary file, then, by means of OLE, tell the Excel application to import the data in that file, into a specified spreadsheet range? It seems to me that this would be well worth an experiment . . .

Replies are listed 'Best First'.
Re^2: Win32::OLE Excel temporary objects destruction by glasswalk3r (Friar) on Nov 23, 2017 at 13:23 UTC
I would like to reinforce the suggestion from sundialsvc4... you can easy do it in SQLite database and read from this DB from the Excel file, as soon as you open it. Easier to do, probably with much better performance and you would also have some added flexibility to select what to read from the DB! Alceu Rodrigues de Freitas Junior --------------------------------- "You have enemies? Good. That means you've stood up for something, sometime in your life." - Sir Winston Churchill	[reply]

Replies are listed 'Best First'.

Re^2: Win32::OLE Excel temporary objects destruction
by glasswalk3r (Friar) on Nov 23, 2017 at 13:23 UTC

I would like to reinforce the suggestion from sundialsvc4... you can easy do it in SQLite database and read from this DB from the Excel file, as soon as you open it.

Easier to do, probably with much better performance and you would also have some added flexibility to select what to read from the DB!

Alceu Rodrigues de Freitas Junior
---------------------------------
"You have enemies? Good. That means you've stood up for something, sometime in your life." - Sir Winston Churchill

[reply]