int i, j;
for (i = 0; i <= 50; i++)
{
for (j = 0; j <= 20; j++)
gcSpreadSheet1.ActiveSheet.SetValue(i, j, "test");
}
GrapeCity.Xaml.SpreadSheet.Data.PrintInfo printset = new GrapeCity.Xaml.SpreadSheet.Data.PrintInfo();
printset.Orientation = GrapeCity.Xaml.SpreadSheet.Data.PrintPageOrientation.Portrait;
printset.PageOrder = GrapeCity.Xaml.SpreadSheet.Data.PrintPageOrder.Auto;
printset.PageRange = "1-3";
printset.PaperSize = new GrapeCity.Xaml.SpreadSheet.Data.PaperSize(GrapeCity.Xaml.SpreadSheet.Data.PaperKind.Letter);
//printset.PaperSize = new GrapeCity.Xaml.SpreadSheet.Data.PaperSize(600, 300);
//printset.PaperSize = new GrapeCity.Xaml.SpreadSheet.Data.PaperSize();
gcSpreadSheet1.Sheets[0].PrintInfo = printset;
For i = 0 To 50
For j = 0 To 20
GcSpreadSheet1.ActiveSheet.SetValue(i, j, "test")
Next j
Next i
Dim printset As New GrapeCity.Xaml.SpreadSheet.Data.PrintInfo()
printset.Orientation = GrapeCity.Xaml.SpreadSheet.Data.PrintPageOrientation.Portrait
printset.PageOrder = GrapeCity.Xaml.SpreadSheet.Data.PrintPageOrder.Auto
printset.PageRange = "1-3"
'printset.PaperSize = new GrapeCity.Xaml.SpreadSheet.Data.PaperSize(GrapeCity.Xaml.SpreadSheet.Data.PaperKind.Letter)
printset.PaperSize = New GrapeCity.Xaml.SpreadSheet.Data.PaperSize(600, 300)
'printset.PaperSize = new GrapeCity.Xaml.SpreadSheet.Data.PaperSize()
GcSpreadSheet1.Sheets(0).PrintInfo = printset