Multiple Sheets and Multiple Tables

[chen...@gmail.com]

Hi Igor,

Hope you are doing well. Your product looks very good, I'm interested in it and I spent some time to test it but I met some issues really need your quick guidance of how to make it (if XLWB can support it).

1. Multiple Sheets -
One of my requirements is to generate one excel file with multiple sheets, and in each sheets, the template is the same - like your order form, however the number of sheets is dynamic - 5 orders create 5 sheets for example and sheet name is also dynamic - it will be order number for example. Is it possible?

2. Multiple Sheets - Complex
Another requirement is to generate one excel file with multiple sheets, number of sheets and sheet name is fixed however each sheets the context is totally different. Is it possible?

3. Multiple tables in one sheet
One requirement is like your order form but the footer part is also a table(grid) with header and multiple lines. Is it possible?

4. Signature (picture)
One requirement is once the order form is generated, the last line I want to paste a "Signature Picture". Is it possible?

Thanks for your guide and wish you have a nice day.

Stan

[Igor]

Hi Stan,

1. Multiple Sheets - 
   One of my requirements is to generate one excel file with multiple sheets, and in each sheets, the template is the same - like your order form, however the number of sheets is dynamic - 5 orders create 5 sheets for example and sheet name is also dynamic - it will be order number for example. Is it possible?

Yes, it is possible, here is example. 

2. Multiple Sheets - Complex
   Another requirement is to generate one excel file with multiple sheets, number of sheets and sheet name is fixed however each sheets the context is totally different. Is it possible?

Yes, You able to insert any number of sheets into excel file: 

3. Multiple tables in one sheet
   One requirement is like your order form but the footer part is also a table(grid) with header and multiple lines. Is it possible?

Yes, it is possible to place any number of tables (subtables) in any combination. Moreover, You able to bring to sheet almost any visual formatting you want.

4. Signature (picture)
   One requirement is once the order form is generated, the last line I want to paste a "Signature Picture". Is it possible?

Yes, of cource. Here is example of static picture (logo). Here and here and here are examples of dynamic pictures, where bitmaps are passed from printing program to excel in runtime.   

Best regards, Igor.