// 新規ワークブックの作成 var workbook = new GrapeCity.Documents.Excel.Workbook(); var fileStream = this.GetResourceStream("xlsx\\PageSetup Print Area.xlsx"); workbook.Open(fileStream); IWorksheet worksheet = workbook.Worksheets[0]; // 印刷範囲と印刷タイトルを設定 worksheet.PageSetup.PrintArea = "$D$5:$G$10"; worksheet.PageSetup.PrintTitleRows = "$5:$10"; worksheet.PageSetup.PrintTitleColumns = "$D:$G"; // xlsx ファイルに保存 workbook.Save("ConfigPrintArea.xlsx");
' 新規ワークブックの作成 Dim workbook As New Workbook Dim fileStream = GetResourceStream("PageSetup Print Area.xlsx") workbook.Open(fileStream) Dim worksheet As IWorksheet = workbook.Worksheets(0) ' 印刷範囲と印刷タイトルを設定 worksheet.PageSetup.PrintArea = "$D$5:$G$10" worksheet.PageSetup.PrintTitleRows = "$5:$10" worksheet.PageSetup.PrintTitleColumns = "$D:$G" ' xlsx ファイルに保存 workbook.Save("ConfigPrintArea.xlsx")