PlanetSquires Forums

Support Forums => Other Software and Code => Topic started by: Petrus Vorster on December 17, 2012, 08:41:26 AM

Title: Export to Excel problem
Post by: Petrus Vorster on December 17, 2012, 08:41:26 AM
Hi
I am having problems understanding how the Powerbasic com browser works. In the PB10 folder there are some examples on how to export a few columns of info to Excel.
It uses the EXCEL.INC file.
Somehow I cannot get Firefly to read it. Regardless of where I place it I always get the same error "Unable to find/not accessible".
The example seems easy enough and works fine if you compile it straight from PB10, but as part of my FF project I want to write a simple module function to export any listview to Excel.
I searched all over this forum on how to do this, but I could not find any on this.
Sorry, I am taking a bit long to grasp this Com thing... :(

Thanks for the patience!
Title: Re: Export to Excel problem
Post by: Petrus Vorster on December 17, 2012, 08:54:26 AM
Ok, some progress.
I used the Typlib browser from JoseRoca and it created an Excel.inc that can be included.
Now just to figure out how to get that listview-to-excel sheet function going!

Hope im on the right track here!
Title: Re: Export to Excel problem
Post by: Petrus Vorster on December 17, 2012, 09:06:52 AM
Ok, no progress. HELP....???
Title: Re: Export to Excel problem
Post by: Petrus Vorster on December 18, 2012, 05:35:15 PM
Solved! Thanks to Paul.
I created a Module function that will export any listview to Excel.
It even sets the Excell columns to the same sizes as the listview and opens the file afterwards.
Thanks all!