//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet sheet = workbook.Worksheets[0]; sheet.Range["F2, F4"].Value = "This is a test string of overflow"; sheet.Range["F6, F8"].Value = "This is a test string of overflow with right alignment"; sheet.Range["F6, F8"].HorizontalAlignment = HorizontalAlignment.Right; sheet.Range["D8, H4"].Value = 123; //Other settings sheet.Range["A1:J10"].Borders.LineStyle = BorderLineStyle.Thin; // Save to a pdf file workbook.Save("Overflow.pdf");
' Create a new Workbook Dim workbook As New Workbook Dim sheet As IWorksheet = workbook.Worksheets(0) sheet.Range("F2, F4").Value = "This is a test string of overflow" sheet.Range("F6, F8").Value = "This is a test string of overflow with right alignment" sheet.Range("F6, F8").HorizontalAlignment = HorizontalAlignment.Right sheet.Range("D8, H4").Value = 123 'Other settings sheet.Range("A1:J10").Borders.LineStyle = BorderLineStyle.Thin ' save to a pdf file workbook.Save("Overflow.pdf")