Search
Follow Us
Categories
- Success Stories(157)
Archives
Category Archive: Aspose.Cells Product Family
Convert Excel Files to Image in Python
In various cases, Excel spreadsheets are required to be embedded in the web or desktop applications. One of the solutions in such cases is the conversion of Excel worksheets to image formats. In this article, you will learn how to convert Excel XLSX or XLS to PNG, JPEG, SVG, or other images in Python.
Merge or Unmerge Cells in an Excel Worksheet using C++
Merging and unmerging cells is a simple and commonly used feature of Microsoft Excel. Merging cells might prove to be helpful in scenarios, for example, when you have a worksheet with multiple columns that share the same heading. You can merge the cells above the columns to give them a common heading. In case merged cells are no longer required, you can unmerge them just as easily. You might need to perform these tasks within your C++ applications. For that, this article will teach you how to merge and unmerge cells in Excel worksheets programmatically using C++.
Convert Excel Files to HTML in PHP
In order to embed Excel spreadsheets within your web pages, you need to convert them into either images or HTML content. Since HTML is more suitable for websites, therefore, this article covers how to convert Excel XLSX or XLS files to HTML pages in PHP.
Split Text to Columns in Excel using Java
MS Excel provides the Text to Columns feature to split the text into multiple columns. The splitting can be based on a blank space, a comma, a special character, etc. In order to automate the feature, this article covers how to perform Excel's Text to Columns from within your Java applications. The step-by-step guide and code sample will show you how to split text in a column in an Excel worksheet.
Split Text into Columns in Excel Files using C++
Microsoft Excel allows splitting text into multiple columns using separators like blank space, comma, or other characters. This feature can be helpful in scenarios such as converting the comma-separated data exported from a database table to tabular form. To that end, this article will teach you how to split text into columns in Excel files using C++.
Convert JSON to PDF using Java
Add or Remove AutoFilter in Excel Files using C++
Filtering information in Excel spreadsheets is an important feature. It enables you to hide irrelevant data and show only the data meeting specific criteria. There might be scenarios where filtering data can prove to be helpful. For example, an organization may want to filter out low-performing products from the sales report to analyze and improve their sales strategies. In this article, you will learn how to add or remove AutoFilter in Excel files using C++.
Convert CSV to Excel in Python
CSV (Comma Separated Values) is a commonly used file format to keep, import, and export data from one application to another. Furthermore, most of the datasets in the field of data science are stored in CSV files. However, in certain cases, you have to convert comma separated values in CSV to tabular form in Excel's XLSX or XLS workbooks. For such scenarios, this article covers how to convert CSV files to Excel in Python.
Convert Excel Files to PDF in PHP
Excel spreadsheets are widely used to store and analyze data in the form of rows and columns. However, in various cases, you need to convert the Excel files to PDF before sharing them over the internet. In order to automate Excel to PDF conversion, this article shows how to convert Excel files to PDF programmatically using PHP. Furthermore, advanced options to customize the Excel to PDF conversion are also discussed.
Add Comments in Excel Worksheets using Java
Comments are used to add additional information or to explain a formula in the Excel worksheet. MS Excel also allows you to set the font size, height, width, etc. of the comments. In this article, you will learn how to add comments to the Excel worksheets programmatically using Java. Furthermore, the article will also cover how to format the comments.