Hi:
For a while I have been sorting 12,180 comics I got for nothing (rather for services rendered) from the years 1989 - 2005 and after I had them all bagged and boarded and put in boxes I wanted to look at the data in a better way then the ComicBase software I used let me.
So I exported all the data and made a B4J program to read in the file and make an Excel file with about a 100 spreedsheets in it (one for each box, one for titles with issues combined and one for all)
The attached zip has the complete program and the data it needs to import to make the Excel file
NOT necessarily my best coding work - but a nice example I believe to help someone else along
THINGS THIS DOES: Scaling of pages is set, Headings, Header columns, autoresized columns, auto-wrap column, sorting of spreadsheets in excel file
Thanks for all that helped me along the way especially Erel
Enjoy
For a while I have been sorting 12,180 comics I got for nothing (rather for services rendered) from the years 1989 - 2005 and after I had them all bagged and boarded and put in boxes I wanted to look at the data in a better way then the ComicBase software I used let me.
So I exported all the data and made a B4J program to read in the file and make an Excel file with about a 100 spreedsheets in it (one for each box, one for titles with issues combined and one for all)
The attached zip has the complete program and the data it needs to import to make the Excel file
NOT necessarily my best coding work - but a nice example I believe to help someone else along
THINGS THIS DOES: Scaling of pages is set, Headings, Header columns, autoresized columns, auto-wrap column, sorting of spreadsheets in excel file
Thanks for all that helped me along the way especially Erel
Enjoy