Search
Follow Us
Categories
- Success Stories(157)
Archives
Category Archive: Aspose.Cells Product Family
Convert Excel Files to HTML using Java
Excel spreadsheets allow you to store and well organize the data in tabular form. You can perform computations as well as generate different types of graphs and charts in order to analyze the data. However, in various scenarios, you may need to carry out Excel to HTML conversion to convert worksheets to HTML pages. For example, when embedding the content of the spreadsheets into web pages. In accordance with that, this article aims to cover how to convert Excel XLSX files to HTML programmatically using Java.
Posted in Aspose.Cells Product Family Tagged convert excel to html java, xls to html java, xlsx to html java
Add or Modify VBA Macros in Excel Files using C#
VBA (Visual Basic for Applications) is a programming language that is used in MS Excel files in order to automate the spreadsheets related operations. VBA macros are used to write user-defined functions that let you speed up the tasks you have to perform manually. In this article, you will learn how to work with VBA macros in MS Excel files programmatically. By the end of this article, you will be able to extract, add, and modify VBA macros in Excel workbooks using C#.
Protect and Unprotect Excel Files using C#
MS Excel provides convenient ways of storing and managing small or large amounts of data. Workbooks are widely used to maintain the datasets, analyze the data, perform activities related to finance or human resources, and etc. With the advancement in technology, the ways of getting unauthorized access to data have also been increased. Therefore, MS Excel lets you protect the workbooks using the password. In this article, you will learn how to automate the spreadsheet protection features and protect or unprotect Excel files programmatically using C#.
Find and Replace Text in Excel Spreadsheets using Java
In this post, you will learn how to find and replace text in MS Excel spreadsheets programmatically in Java. In various scenarios, MS Excel spreadsheets consist of a huge amount of data that may spread in multiple sheets. For such cases, the find and replace option could help you minimize the efforts required to update all the occurrences of a particular piece of text. Let's check out how to automate this option when dealing with a large number of spreadsheets from within the Java applications.
Convert JSON to CSV and CSV to JSON using C# or VB.NET
JSON is abbreviated for Javascript Object Notation, which represents the data as key-value pairs. You can convert JSON to CSV and CSV to JSON format as per your requirements. Both of these file formats are suitable for storing and transmitting data.
Convert CSV to PDF or PDF to CSV Programmatically using C# VB.NET
Convert CSV to Excel Files or Excel to CSV using C# VB.NET
Information is sometimes exchanged as key, value pairs, or comma-separated values in different scenarios. You might need to manipulate or convert such comma-separated values (CSV) to Excel (XLS /XLSX) for further processing. Likewise, you can convert Microsoft Excel files XLS/XLSX to CSV in your .NET applications using C# or VB.NET.
Convert MS Excel XLSX Files to DOCX using C#
MS Excel's XLSX files let you keep the tabular data in the form of rows and columns. You can store small, medium, or large-sized data within XLSX worksheets quite easily. However, there could be a case when you need to convert the spreadsheet data to a word processing format. For such cases, in this article, you will learn how to convert Excel XLSX to DOCX using C#. In addition, you will see how to customize the XLSX to DOCX conversion. So let's begin.
Posted in Aspose.Cells Product Family Tagged excel to word csharp, xls to docx csharp, xlsx to docx csharp
Create Excel Files using Java without MS Office
MS Excel spreadsheets have made it easier to keep and share a large amount of tabular data. Not only this, you can perform various operations such as applying formulas, generating charts and graphs, sorting and filtering data, and so on. In this article, you will learn how to implement Excel automation features from within your Java applications. After reading this article, you will be able to create MS Excel XLSX or XLS files from scratch using Java. In addition, this article will cover how to update an existing Excel file, generate charts, and add tables in Excel worksheets.
Convert Excel XLS/XLSX to HTML using C#
Excel to HTML conversion could be useful in various scenarios such as converting sheets to web pages or embedding the content of the sheets within the web applications and so on. In this article, you will learn how to convert MS Excel (XLS/XLSX) files to HTML using C#. Furthermore, you will come to know how to use additional options to customize the Excel to HTML conversion.