B4J Code Snippet Excel Spreadsheet Example

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

 

[Mashiane]

This is worth a check... ta!