AsposeCellsBlog

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

// Specify that you want to load TSV file.
LoadOptions opts = new LoadOptions(LoadFormat.TSV);

// Load your sample TSV file inside the Workbook object using specified LoadOptions.
Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook(dirPath + "sampleConvertTSVToExcelFormats.tsv", opts);

// Save TSV file to XLS format.

AsposeCellsBlog

// The following sample code uses Aspose.Cells API to ... 
// Generate Excel Cell Data with Formatting and Save to XLSX, PDF and HTML formats.

//Create Empty Workbook.
Workbook wb = new Workbook();

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

//Add Month Data by Rows and Column Indices.

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.

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

// 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/";

// 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

// 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

// 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 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

// 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.