Exporting

With M!Table you can export a table to M$ Excel, Open Office Calc or into a HTML file.

Functions
MTblExportToExcel
MTblExportToExcelEx
MTblExportToHTML Deprecated!
MTblExportToOOCalc Deprecated!

MTblSetExportSubstColor
MTblGetExportSubstColor
MTblClearExportSubstColors
MTblEnumExportSubstColors

Column Flags
MTBL_COL_FLAG_EXPORT_AS_TEXT

Messages
MTM_QueryExcelColWidth
MTM_QueryExcelNumberFormat
MTM_QueryExcelRowHeight
MTM_QueryExcelValue


Hints and tips

Substitute colors
Substitution of a color affects that a table color - regardless for what the color is used (as text color, background color, line color etc. ) - is replaced with another color in the export. Use MTblSetExportSubstColor to substitute a color. Please note that the color substitutions are not automatically cleared when the export is done! To clear all color substitutions call MTblClearExportSubstColors. Consider you want to export a table to Excel with color substitutions, and after that to a HTML file without color substitutions, you have to do something like this:

! Substitute some colors
Call MTblSetExportSubstColor( hWndTbl, COLOR_Blue, COLOR_Red )
Call MTblSetExportSubstColor( hWndTbl, COLOR_Yellow, COLOR_Green )
! Export to Excel
Call MTblExportToExcel( ... )
! Clear the color substitutions
Call MTblClearExportSubstColors( hWndTbl )
! Export to HTML file
Call MTblExportToHTML( ... )

 

Created with the Personal Edition of HelpNDoc: Easily create Help documents