Archive for September, 2011

Import Excel Worksheets

September 8, 2011 Leave a comment

Of course Sunset Reports can import data from Excel, basically making a worksheet range a data source.   But, you can use Excel for something difference!  Import a worksheet range as a report design. The import will do cell sizes, fonts, colors, borders, alignment, and text.   The import creates a report that “looks like” the original Excel worksheet.   Formulas are not translated since they would not work and need to be reprogrammed, but the formulas are brought in and stored in a table cell’s tag property for reference.   The formatting is not 100%, but it is real close.   Here is a picture of the Import Report Design form: