Skip to content

Instantly share code, notes, and snippets.

View AsposeCellsBlog's full-sized avatar

AsposeCellsBlog AsposeCellsBlog

  • http://products.aspose.com/cells/
View GitHub Profile
@AsposeCellsBlog
AsposeCellsBlog / Convert_CSV_to_XLSX_format.java
Created November 22, 2018 16:21
Convert CSV to XLSX format - Java
// Directory path for input and output files.
String dirPath = "D:\\Download\\";
// Load your sample CSV file inside the Workbook object.
com.aspose.cells.Workbook wb = new com.aspose.cells.Workbook(dirPath + "sampleConvertCSVToExcelFormats.csv");
// Save CSV file to XLSX format.
wb.save(dirPath + "outputConvertCSVToExcelFormats.xlsx", SaveFormat.XLSX);
@AsposeCellsBlog
AsposeCellsBlog / Convert_CSV_to_XLS_format.java
Created November 22, 2018 16:20
Convert CSV to XLS format - Java
// Directory path for input and output files.
String dirPath = "D:\\Download\\";
// Load your sample CSV file inside the Workbook object.
com.aspose.cells.Workbook wb = new com.aspose.cells.Workbook(dirPath + "sampleConvertCSVToExcelFormats.csv");
// Save CSV file to XLS format.
wb.save(dirPath + "outputConvertCSVToExcelFormats.xls", SaveFormat.EXCEL_97_TO_2003);
@AsposeCellsBlog
AsposeCellsBlog / Convert_CSV_to_XLSB_format.cs
Created November 22, 2018 15:38
Convert CSV to XLSB format - C#
// Directory path for input and output files.
string dirPath = "D:\\Download\\";
// Load your sample CSV file inside the Workbook object.
Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook(dirPath + "sampleConvertCSVToExcelFormats.csv");
// Save CSV file to XLSB format.
wb.Save(dirPath + "outputConvertCSVToExcelFormats.xlsb", SaveFormat.Xlsb);
@AsposeCellsBlog
AsposeCellsBlog / Convert_CSV_to_XLSM_format.cs
Created November 22, 2018 15:27
Convert CSV to XLSM format - C#
// Directory path for input and output files.
string dirPath = "D:\\Download\\";
// Load your sample CSV file inside the Workbook object.
Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook(dirPath + "sampleConvertCSVToExcelFormats.csv");
// Save CSV file to XLSM format.
wb.Save(dirPath + "outputConvertCSVToExcelFormats.xlsm", SaveFormat.Xlsm);
@AsposeCellsBlog
AsposeCellsBlog / Convert_CSV_to_XLSX_format.cs
Created November 22, 2018 15:20
Convert CSV to XLSX format - C#
// Directory path for input and output files.
string dirPath = "D:\\Download\\";
// Load your sample CSV file inside the Workbook object.
Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook(dirPath + "sampleConvertCSVToExcelFormats.csv");
// Save CSV file to XLSX format.
wb.Save(dirPath + "outputConvertCSVToExcelFormats.xlsx", SaveFormat.Xlsx);
@AsposeCellsBlog
AsposeCellsBlog / Convert_CSV_to_XLS_format.cs
Created November 22, 2018 15:18
Convert CSV to XLS format - C#
// Directory path for input and output files.
string dirPath = "D:\\Download\\";
// Load your sample CSV file inside the Workbook object.
Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook(dirPath + "sampleConvertCSVToExcelFormats.csv");
// Save CSV file to XLS format.
wb.Save(dirPath + "outputConvertCSVToExcelFormats.xls", SaveFormat.Excel97To2003);
@AsposeCellsBlog
AsposeCellsBlog / Create_Microsoft_Excel_Line_Chart.java
Created November 22, 2018 14:54
Create Microsoft Excel Line Chart - Java
// Directory path of input and output files.
String dirPath = "D:/Download/";
// Load source Excel file containing the chart data.
Workbook wb = new Workbook(dirPath + "sampleCreateMicrosoftExcelLineChart.xlsx");
// Access first worksheet.
Worksheet ws = wb.getWorksheets().get(0);
// Specify dimensions of the chart.
@AsposeCellsBlog
AsposeCellsBlog / Excel_Cell_Formatting_Bold_Italic_Single_Double_Underline.java
Created November 22, 2018 12:53
Excel Cell Formatting in Java - Bold, Italic, Single and Double Underline
// Directory path for output.
String dirPath = "D:\\Download\\";
// Create workbook object.
com.aspose.cells.Workbook wb = new Workbook();
// Get default style of the workbook.
Style st = wb.getDefaultStyle();
// Set the font name, size, vertical and
@AsposeCellsBlog
AsposeCellsBlog / Excel_Cell_Formatting_Bold_Italic_Single_Double_Underline.cs
Created November 22, 2018 12:52
Excel Cell Formatting in C# - Bold, Italic, Single and Double Underline
// Directory path for output.
String dirPath = "D:\\Download\\";
// Create workbook object.
Aspose.Cells.Workbook wb = new Workbook();
// Get default style of the workbook.
Style st = wb.DefaultStyle;
// Set the font name, size, vertical and
@AsposeCellsBlog
AsposeCellsBlog / Create_Microsoft_Excel_Line_Chart.cs
Created November 22, 2018 10:47
Create Microsoft Excel Line Chart - C#
// Directory path of input and output files.
string dirPath = "D:/Download/";
// Load source Excel file containing the chart data.
Workbook wb = new Workbook(dirPath + "sampleCreateMicrosoftExcelLineChart.xlsx");
// Access first worksheet.
Worksheet ws = wb.Worksheets[0];
// Specify dimensions of the chart.