AsposeCellsBlog

// Directory path for output Excel file.
String dirPath = "D:\\Download\\";

// Create empty workbook object.
Workbook wb = new Workbook();

// Set the default style of the workbook.
Style defultStyle = wb.DefaultStyle;
defultStyle.Font.Name = "Calibri";
defultStyle.Font.Size = 11;

AsposeCellsBlog

// Directory path for output Excel file.
String dirPath = "D:\\Download\\";

// Create empty workbook object.
Workbook wb = new Workbook();

// Set the default style of the workbook.
Style defultStyle = wb.getDefaultStyle();
defultStyle.getFont().setName("Calibri");
defultStyle.getFont().setSize(11);

AsposeCellsBlog

// Directory path for input and output Excel files.
String dirPath = "D:/Download/";

// Load the input Excel file containing the sample data.
Workbook wb = new Workbook(dirPath + "sampleUseAutoFilterToFilterExcelData.xlsx");

// Access first worksheet.
Worksheet ws = wb.Worksheets[0];

// Apply auto filter to the range.

AsposeCellsBlog

// Directory path for input and output Excel files.
String dirPath = "D:/Download/";

// Load the input Excel file containing the sample data.
Workbook wb = new Workbook(dirPath + "sampleUseAutoFilterToFilterExcelData.xlsx");

// Access first worksheet.
Worksheet ws = wb.getWorksheets().get(0);

// Apply auto filter to the range.

AsposeCellsBlog

// Path of input Excel file.
intrusive_ptr<Aspose::Cells::System::String> inputExcelFile = new Aspose::Cells::System::String("D:/Download/sampleUseAutoFilterToFilterExcelData.xlsx");

// Path of output Excel file.
intrusive_ptr<Aspose::Cells::System::String> outputExcelFile = new Aspose::Cells::System::String("D:/Download/outputUseAutoFilterToFilterExcelData.xlsx");

// Declaration of some variables to be used later.
intrusive_ptr<Aspose::Cells::System::String> strRng;
intrusive_ptr<Aspose::Cells::System::String> strCriteria;

AsposeCellsBlog

// Directory path of input and output files.
string dirPath = "D:/Download/";

// Load source Excel file containing the chart data.
Workbook wb = new Workbook(dirPath + "sampleCreateMicrosoftExcelColumnChart.xlsx");

// Access first worksheet.
Worksheet ws = wb.Worksheets[0];

// Specify dimensions of the chart.

AsposeCellsBlog

// Directory path of input and output files.
String dirPath = "D:/Download/";

// Load source Excel file containing the chart data.
Workbook wb = new Workbook(dirPath + "sampleCreateMicrosoftExcelColumnChart.xlsx");

// Access first worksheet.
Worksheet ws = wb.getWorksheets().get(0);

// Specify dimensions of the chart.

AsposeCellsBlog

// Path of input Excel file.
intrusive_ptr<Aspose::Cells::System::String> inputExcelFile = new Aspose::Cells::System::String("D:/Download/sampleCreateMicrosoftExcelColumnChart.xlsx");

// Path of output Excel file.
intrusive_ptr<Aspose::Cells::System::String> outputExcelFile = new Aspose::Cells::System::String("D:/Download/ccoutputCreateMicrosoftExcelColumnChart.xlsx");

// Load source Excel file containing the chart data.
intrusive_ptr<Aspose::Cells::IWorkbook> wb = Aspose::Cells::Factory::CreateIWorkbook(inputExcelFile);

// Access first worksheet.

AsposeCellsBlog

// Directory path of input and output files.
string dirPath = "D:/Download/";

// Specify load options Excel97To2003 i.e. XLS format. 
LoadOptions opts = new LoadOptions(LoadFormat.Excel97To2003);
            
// Load the input XLS file inside the Aspose.Cells workbook object.
Aspose.Cells.Workbook wb = new Workbook(dirPath + "SampleConvertMicrosoftExcelXLSToXLSX.xls", opts);

// Save the workbook as output XLSX file.

AsposeCellsBlog

// Directory path of input and output files.
String dirPath = "D:/Download/";

// Specify load options Excel97To2003 i.e. XLS format. 
LoadOptions opts = new LoadOptions(LoadFormat.EXCEL_97_TO_2003);

// Load the input XLS file inside the Aspose.Cells workbook object.
com.aspose.cells.Workbook wb = new Workbook(dirPath + "SampleConvertMicrosoftExcelXLSToXLSX.xls", opts);

// Save the workbook as output XLSX file.