Search
Follow Us
Categories
- Success Stories(157)
Archives
Author Archives: Usman Aziz
Find and Replace Text in Excel using Python
Excel spreadsheets often contain thousands of records in multiple sheets. In such cases, finding and replacing a particular text manually could be a hectic task. Therefore, MS Excel provides the find and replace option to update the desired text with a single click. In this article, you will learn how to find and replace text in Excel files programmatically in Python.
Encrypt and Decrypt Excel Files in Python
Security and privacy have always been important aspects of safeguarding data. Since Excel files are widely used to store data, safety is ensured to avoid tampering and unauthorized access. In accordance with that, this article covers how to encrypt and decrypt Excel files in Python.
Convert LaTeX to Word using C#
LaTeX's TEX is a popular format that is used to write articles, books, and other publications. It uses different tags to insert text, graphics, mathematical equations, symbols, etc. in the document. In certain cases, you may need to convert the LaTeX file to a Word format programmatically. For such cases, this article covers how to convert a LaTeX file (.tex) to Word format using C#.
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.
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.
Convert Email to HTML in Python
Email messages are often required to be converted to HTML format to embed them within the web pages. In order to automate this conversion, in this article, you will learn how to convert emails to HTML using Python. Particularly, the article will cover how to convert EML or MSG email files to HTML pages.