I would like to create MS EXCEL files (.xlsx) from a CGI program and not use MS Office. I've been using
OpenXML Libraries by DocxFactory. It works well when I use a predefined EXCEL template and a buffer handle.
I would like to be able to have two tables setup in the template. Each table would have it's own data source (buffer handle). Is something like this possible?
The item table in the template uses this procedure call:
run xlsx_replaceLongRange( input "stXlsx",
input buffer Item:handle,
input "ItemNum = Item.ItemNum" +
",ItemName = Item.ItemName", +
",Price = Item.Price" +
",OnHand = Item.OnHand" ,
input "",
input "" ).
I would to use a customer table in the same template with a similar procedure call:
run xlsx_replaceLongRange( input "stXlsx",
input buffer Customer:handle,
input "CustNum = Custmer.CustNum" +
",CustName = Customer.CustName",
input "",
input "" ).
OpenXML Libraries by DocxFactory. It works well when I use a predefined EXCEL template and a buffer handle.
I would like to be able to have two tables setup in the template. Each table would have it's own data source (buffer handle). Is something like this possible?
The item table in the template uses this procedure call:
run xlsx_replaceLongRange( input "stXlsx",
input buffer Item:handle,
input "ItemNum = Item.ItemNum" +
",ItemName = Item.ItemName", +
",Price = Item.Price" +
",OnHand = Item.OnHand" ,
input "",
input "" ).
I would to use a customer table in the same template with a similar procedure call:
run xlsx_replaceLongRange( input "stXlsx",
input buffer Customer:handle,
input "CustNum = Custmer.CustNum" +
",CustName = Customer.CustName",
input "",
input "" ).