Search
Follow Us
Categories
- Success Stories(157)
Archives
Category Archive: Aspose.Cells Product Family
Convert Chart to PDF and Images like JPG, PNG, WMF in Java
You can efficiently convert a chart to image or PDF in your Java applications. Aspose.Cells for Java API offer a lot of features to create, edit, or manipulate XLSX, XLS, XLSM, XLSB, and other supported file formats without needing to install Microsoft Excel. In this article, we will be exploring the support for chart rendering to image and PDF file format.
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.
Posted in Aspose.Cells Product Family Tagged add autofilter in xlsx, autofilter in excel, remove autofilter
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. … Continue Reading
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. … Continue Reading
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
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 … Continue Reading
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:
… Continue ReadingCreate 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 … Continue Reading
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. There could be the case … Continue Reading