Add or Remove AutoFilter in Excel File (XLSX/XLS) using C#
XLSX and XLS file formats are frequently used to manipulate huge data. Likewise, AutoFilters are used to organize data in Excel files. You can easily add or remove data filters in Excel files with Aspose.Cells for .NET API. Filters can be used to quantify some data to extract some meaningful information. For example, an organization wants to filter the months with low sales, in order to devise and improve their strategies.
Convert CSV to Excel or Excel to CSV File using Java
CSV file format is used to save comma-separated values. CSV to Excel conversion is helpful when there are numbers involved in the input data and you need to perform some calculations. Likewise, Excel to CSV conversion is helpful in some scenarios, like serialization of data in some cases. Let us explore the inter-conversion between CSV and Excel file format.
Convert MS Excel Files to HTML using Python
MS Excel files are very much in business for storing, organizing, and analyzing a large amount of data. In certain cases, developers also prefer to use Excel files instead of a database to keep the records. However, in order to view the data in Excel files, you need to install MS Excel. Furthermore, you can not view the content of the Excel files from within your applications. Excel to HTML conversion is one of the possible solutions in such cases.
Create MS Excel Files using Python - Python Excel API
Python) has become one of the ruling programming languages in the past few years. The usefulness and popularity of Python have immensely grown the community of Python enthusiasts. On the other hand, spreadsheet automation has made it easier to keep, organize, and play with a large amount of data from within the web or desktop applications. This article aims to put together Python and spreadsheet automation to show you how to create Excel XSLX or XLS files using Python.
Convert Excel Files to PDF using Java
Excel to PDF conversion might be required in various scenarios for exporting tabular data from worksheets to PDF pages. In this article, you’ll learn how to convert Excel files to PDF using Java in order to automate XLS/XLSX to PDF conversion within your web or desktop applications.
Java Excel to PDF Converter API - Installation Convert Excel XLS/XLSX to PDF using Java Convert Excel to PDF with Particular Compliance using Java Render One PDF Page Per Sheet using Java Convert a Range of Sheets to PDF using Java Java Excel to PDF Converter API - Installation Aspose.
Create Excel XLSX/XLS File in Node.js Applications - A Complete Guide
In this article, I’ll show you how to implement Excel automation and create Excel XLSX/XLS file in Node.js applications programmatically.
Spreadsheets have made it possible to store a huge amount of data in the form of rows, columns, and sheets. In addition, you can perform a variety of operations on the data such as sorting, applying mathematical formulas, generating charts and graphs, and much more. In the current era of the digital world, automation has taken the place of manual work.
Merge or Unmerge Cells in Excel Worksheet with C#
In this article, you will learn about how to merge or unmerge Excel cells in a worksheet. Generally, merging cells refers to one or more cells joined together to form a large cell. However, the adjacent cells can be merged vertically or horizontally. Whereas, converting a large cell into multiple cells is known as unmerging or splitting cells in Excel worksheet. Let us explore the following use cases:
Merge Excel Cells in Worksheet with C# Unmerge Excel Cells in Worksheet with C# Merge a Range of Excel Cells in Worksheet with C# Unmerge a Range of Excel Cells in Worksheet with C# Merge Excel Cells of Named Range in Worksheet with C# Merge Excel Cells in Worksheet with C# You can easily merge cells in excel worksheet with Aspose.
Create MS Excel Spreadsheets in C++ without MS Office - A Comprehensive Guide
Previously, I have written a post on how to implement Excel automation features and create Excel XLS/XLSX files from scratch using C#. Today, I’ll show you how to create Excel workbooks, insert data to Excel worksheets, calculate formulas, and create charts and tables in worksheets using C++. All the spreadsheet automation features will be powered by C++ Excel API - Aspose.Cells for C++.
Aspose.Cells for C++ is a native C++ library that lets you create, read, parse, and convert spreadsheet documents without requiring Microsoft Excel.
Import Data from JSON to Excel Worksheet in C# .NET
MS Excel provides a variety of features to keep and organize tabular data in the form of worksheets. Along with data organization, you can perform various operations such as data sorting, graph plotting, mathematical computations and etc. JSON, on the other hand, is a widely used format to store and transmit the data in the form of key-value pairs. Most often, it is used to transmit data from the server to the web pages.
Find and Replace Text in Excel Spreadsheets using C#
The Excel spreadsheets have minimized the efforts required to keep the huge data and perform complex calculations automatically. Excel automation was the next big achievement that has streamlined the way of creating Excel spreadsheets and performing a variety of operations on the data programmatically.
Finding and replacing text in Excel is one of the frequently performed operations in Excel automation. Therefore, in this article, I will show you how to find and replace text in large Excel spreadsheets programmatically in C# with a few lines of code.