Excel Buffer Table

  • Article

Used when writing data to Excel.

Instead of writing directly to Excel, data is written to the Excel Buffer table as one record per Excel cell holding additional information about the data, such as data type (number or text) and other properties. The data is then written to Excel based on the information in the table.

List of Fields in the Table

Field Location
Formula2 Field, Excel Buffer Table General Ledger
Cell Value as Text Field, Excel Buffer Table General Ledger
Italic Field, Excel Buffer Table General Ledger
xlRowID Field, Excel Buffer Table General Ledger
Underline Field, Excel Buffer Table General Ledger
Comment Field, Excel Buffer Table General Ledger
xlColID Field, Excel Buffer Table General Ledger
Bold Field, Excel Buffer Table General Ledger
Column No. Field, Excel Buffer Table General Ledger
Formula Field, Excel Buffer Table General Ledger
NumberFormat Field, Excel Buffer Table General Ledger
Formula4 Field, Excel Buffer Table General Ledger
Row No. Field, Excel Buffer Table General Ledger
Formula3 Field, Excel Buffer Table General Ledger
Formula2 Field, Excel Buffer Table General Ledger
Cell Value as Text Field, Excel Buffer Table General Ledger
Italic Field, Excel Buffer Table General Ledger
xlRowID Field, Excel Buffer Table General Ledger
Underline Field, Excel Buffer Table General Ledger
Comment Field, Excel Buffer Table General Ledger
xlColID Field, Excel Buffer Table General Ledger
Bold Field, Excel Buffer Table General Ledger
Column No. Field, Excel Buffer Table General Ledger
Formula Field, Excel Buffer Table General Ledger
NumberFormat Field, Excel Buffer Table General Ledger
Formula4 Field, Excel Buffer Table General Ledger
Row No. Field, Excel Buffer Table General Ledger
Cell Type Field, Excel Buffer Table General Ledger
Formula3 Field, Excel Buffer Table General Ledger
Formula2 Field, Excel Buffer Table General Ledger
Cell Value as Text Field, Excel Buffer Table General Ledger
Italic Field, Excel Buffer Table General Ledger
xlRowID Field, Excel Buffer Table General Ledger
Underline Field, Excel Buffer Table General Ledger
Comment Field, Excel Buffer Table General Ledger
xlColID Field, Excel Buffer Table General Ledger
Bold Field, Excel Buffer Table General Ledger
Column No. Field, Excel Buffer Table General Ledger
Formula Field, Excel Buffer Table General Ledger
NumberFormat Field, Excel Buffer Table General Ledger
Formula4 Field, Excel Buffer Table General Ledger
Row No. Field, Excel Buffer Table General Ledger
Formula3 Field, Excel Buffer Table General Ledger
Formula2 Field, Excel Buffer Table General Ledger
Cell Value as Text Field, Excel Buffer Table General Ledger
Italic Field, Excel Buffer Table General Ledger
xlRowID Field, Excel Buffer Table General Ledger
Underline Field, Excel Buffer Table General Ledger
Comment Field, Excel Buffer Table General Ledger
xlColID Field, Excel Buffer Table General Ledger
Bold Field, Excel Buffer Table General Ledger
Column No. Field, Excel Buffer Table General Ledger
Formula Field, Excel Buffer Table General Ledger
NumberFormat Field, Excel Buffer Table General Ledger
Formula4 Field, Excel Buffer Table General Ledger
Row No. Field, Excel Buffer Table General Ledger
Formula3 Field, Excel Buffer Table General Ledger

See Also

Other Resources

Sending Data to Microsoft Excel