Example

The following example specifies to print only the rows and columns containing data and prints the active sheet.

C++

// Print the portion of the sheet that contains data
m_Spread1.SetPrintUseDataMax(TRUE);
m_Spread1.PrintSheet(PrintFlagsNone);

Visual Basic

' Print the portion of the sheet that contains data
fpSpread1.PrintUseDataMax = True
fpSpread1.PrintSheet PrintFlagsNone