public override void Execute(GrapeCity.Documents.Excel.Workbook workbook) { object[,] data = new object[, ] { { "Name", "City", "Birthday", "Sex", "Weight", "Height" }, { "Bob", "NewYork", new DateTime(1968, 6, 8), "male", 80, 180 }, { "Betty", "NewYork", new DateTime(1972, 7, 3), "female", 72, 168 }, { "Gary", "NewYork", new DateTime(1964, 3, 2), "male", 71, 179 }, { "Hunk", "Washington", new DateTime(1972, 8, 8), "male", 80, 171 }, { "Cherry", "Washington", new DateTime(1986, 2, 2), "female", 58, 161 }, { "Eva", "Washington", new DateTime(1993, 2, 5), "female", 71, 180 } }; //Set data. IWorksheet sheet = workbook.Worksheets[0]; sheet.Range["A1:F7"].Value = data; sheet.Tables.Add(sheet.Range["A1:F7"], true); //Save csv options CsvSaveOptions options = new CsvSaveOptions(); options.SeparatorString = "-"; //Change the path to real export path when save. workbook.Save(this.CurrentDirectory + "dest.csv", options); }
public override void Execute(GrapeCity.Documents.Excel.Workbook workbook) { //Change the path to real export path when save. XlsxSaveOptions options = new XlsxSaveOptions(); options.Password = "******"; workbook.Save(this.CurrentDirectory + "dest.xlsx", options); }
public override void Execute(GrapeCity.Documents.Excel.Workbook workbook) { IWorksheet sheet = workbook.Worksheets[0]; //set style. sheet.Range["A1"].Value = "Sheet1"; sheet.Range["A1"].Font.Name = "Wide Latin"; sheet.Range["A1"].Font.Color = Color.Red; sheet.Range["A1"].Interior.Color = Color.Green; //change the path to real export path when save. workbook.Save(this.CurrentDirectory + "dest.pdf", SaveFileFormat.Pdf); }
public void DioDocs() { var workbook = new Workbook(); var worksheet = workbook.ActiveSheet; for (var i = 1; i <= ColumnNum; i++) { for (var j = 1; j <= RowNum; j++) { worksheet.Range[i, j].Value = "Hello World!"; } } workbook.Save(Stream.Null); }
public override void Execute(GrapeCity.Documents.Excel.Workbook workbook) { //ToJson&FromJson can be used in combination with spread.sheets product:http://spread.grapecity.com/spreadjs/sheets/ //GrapeCity Documents for Excel import an excel file. //change the path to real source file path. string source = this.CurrentDirectory + "source.xlsx"; workbook.Open(source); //GrapeCity Documents for Excel export to a json string. var jsonstr = workbook.ToJson(); //use the json string to initialize spread.sheets product. //spread.sheets will show the excel file contents. //spread.sheets product export a json string. //GrapeCity Documents for Excel use the json string to initialize. workbook.FromJson(jsonstr); //GrapeCity Documents for Excel export workbook to an excel file. //change the path to real export file path. string export = this.CurrentDirectory + "export.xlsx"; workbook.Save(export); }
public override void Execute(GrapeCity.Documents.Excel.Workbook workbook) { //change the path to real export path when save. workbook.Save(this.CurrentDirectory + "dest.xlsx", SaveFileFormat.Xlsx); }