Re: Witango-Talk: Different excel question
Gene I used PERL with CPAN Spreadsheet::WriteExcel module to do somthing like you want. -- --> Kent Swisher Engineering Tools --> Alcatel-LucentApplication Support Engineer --> Wireline Access Products --> Petaluma, CA 707-792-7116 (on net 2-855-7116) On 6/27/2008 4:28 AM, Wolf, Gene wrote: Creating excel spreadsheets from Witango is trivial but I have a different question. I have been asked to put together an excel workbook containing several tabbed pages. The tabs will contain the part number of a query I am performing and the data on the page that relates to that tab will contain serial numbers of units shipped, along with other information, pertaining to that tabbed part number. Can this be done using Witango? */Gene Wolf/*// /Supervisor, Business Systems/ /DRS Sensors & Targeting Systems-Optronics/ /2330 Commerce Park Drive NE/ /Palm Bay, Florida 32905/ /Phone: 321-309-0685/ / 321-309-0202 (fax)/ Dictionary.com Word of the Day _http://dictionary.reference.com/wordoftheday/_ This e-mail, including any attached files, may contain confidential and privileged information for the sole use of the intended recipient. Any review, use, distribution, or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive information for the intended recipient), please contact the sender by reply e-mail and delete all copies of this message. */"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior written approval from the U.S. Department of State."/*// TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Different excel question
Hi Gene! Can you write XML out of Witango? If your answer is yes, the my answer is YES. Export a complex Excel with many tabs (worksheets). Choose XML as the format for output. View in any text editor (or XML viewer) to see the schema used. You can get the xsd/schema/dtd for Excel, but it usually easier to create a sample of what you want, save as XML and then use the repeating patterns to DYNAMICALLY create new Excel documents from the template. -- Beverly Voth mailto:[EMAIL PROTECTED] tel:(606) 864-0041 -- On Jun 27, 2008, at 7:28 AM, "Wolf, Gene" <[EMAIL PROTECTED]> wrote: Creating excel spreadsheets from Witango is trivial but I have a different question. I have been asked to put together an excel workbook containing several tabbed pages. The tabs will contain the part number of a query I am performing and the data on the page that relates to that tab will contain serial numbers of units shipped, along with other information, pertaining to that tabbed part number. Can this be done using Witango? Gene Wolf Supervisor, Business Systems DRS Sensors & Targeting Systems-Optronics 2330 Commerce Park Drive NE Palm Bay, Florida 32905 Phone: 321-309-0685 321-309-0202 (fax) Dictionary.com Word of the Day http://dictionary.reference.com/wordoftheday/ This e-mail, including any attached files, may contain confidential and privileged information for the sole use of the intended recipient. Any review, use, distribution, or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive information for the intended recipient), please contact the sender by reply e-mail and delete all copies of this message. "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior written approval from the U.S. Department of State." TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Different excel question
Creating excel spreadsheets from Witango is trivial but I have a different question. I have been asked to put together an excel workbook containing several tabbed pages. The tabs will contain the part number of a query I am performing and the data on the page that relates to that tab will contain serial numbers of units shipped, along with other information, pertaining to that tabbed part number. Can this be done using Witango? Gene Wolf Supervisor, Business Systems DRS Sensors & Targeting Systems-Optronics 2330 Commerce Park Drive NE Palm Bay, Florida 32905 Phone: 321-309-0685 321-309-0202 (fax) Dictionary.com Word of the Day http://dictionary.reference.com/wordoftheday/ This e-mail, including any attached files, may contain confidential and privileged information for the sole use of the intended recipient. Any review, use, distribution, or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive information for the intended recipient), please contact the sender by reply e-mail and delete all copies of this message. > "This (document/presentation) may contain technical data as defined in > the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. > Export of this material is restricted by the Arms Export Control Act > (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons > without prior written approval from the U.S. Department of State." > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf