Page 1 of 1

Spreadsheets

Posted: Tue Nov 17, 2015 3:41 pm
by omni
Roger,

We have sometimes been requested to do some very odd looking excel spread sheets for some our clients customers. The one we got recently has about 15 columns, fixed, no problem. Then a space under the row that looks like typing where information is put in (its 3 blank places for stops on loads, most blank), then the next data line in the first format. Goes for about 20 pages. They want that format each week for their loads (this is for trucking).
Told them we could not do it and they are willing to use a report in pdf, but that will make the font so small its not readable on landscape.

is there a known method to create a spreadsheet like this from our data?

If you need a copy I can attach it. It probably sounds like it makes no sense.

Fred
Omni

Re: Spreadsheets

Posted: Tue Nov 17, 2015 4:16 pm
by Sbryan
LibXL is a nice library for generating even complicated spreadsheets. There is a wrapper class for it that uses ot4xb. I believe it is called HBlibXL. I used it for a project and it made it very easy.