>>>I tested with the beta 10 version that I sent to you and the return values are correct. Please see the attached screen shot.
>>
>>Thank you.
>
>BTW -- there are two methods for exporting a table to a workbook. The first method (which you are using) is SaveTableToWorkbook(); this method saves the table into the internal xl_* named cursors. This allows you to be able to add formatting and other features to the workbook before saving. But this is the slowest method to saving a workbook. The second method is SaveTableToWorkbookEx() which saves the table directly to the workbook with limited formatting. The formatting is defaulted by field type and font name/size is set as a property value. This is a much faster output to create the workbook.
Greg,
Could you please help me understand the difference between the SaveTableToWorkBook() and SaveTableToWorkBookEx(). You said:
"This allows you to be able to add formatting and other features to the workbook before saving."
Do you add formatting in code?
Also, if the user does not need to add any formatting and other features, are the resulting XLSX files identical with either method?
TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham