How to type a subscript in Excel. Also learn to type a superscript for a part of text. This page also has macro code to convert a part of text in Excel to be subscript, superscript or strikethrough
Excel VBA – Convert Column Letter to Number
Get Excel VBA code to convert Column Letter to number. The Formula & Excel vba code will get column alphabet letter & return the Column number as value.
Excel VBA – Convert Column Number to English Alphabet Letter
Get Excel vba code & formula to convert column number to letter. Use this function in Excel worksheet or vba macro to get column letter from its column number.
Python CSV File – Read & Write – CSV API
Python CSV read & write code. Using this code read row data from comma separated file & also write data using the CSV Api csvReader & csvWriter modules.
Excel VBA – Copy Workbook – Active or External
Copy Active workbook or any workbook from external path using the inbuilt Excel function workbook.savecopyas. Make a Excel workbook copy to new path.
Python strftime – C, C++ Date Time Formatting
strftime For quick syntax & options help with this function, type >>help (“time.strftime”) . This will list all the basic help that you are in need. If you are looking for a much more advanced option with this function, then refer this table. About this function: This function is used to […]
JSON Parser – Python Code – Convert JSON To Excel CSV
Get JSON Parser in Python that converts JSON to csv or Excel. Sample JSON file is also provided. Code parses JSON by each node & write to CSV file.
JSON Parser – Convert JSON To CSV – Excel VBA Macro
JSON Parser. Get VBA macro code to convert JSON to Excel. This code will Parse JSON fields one by one to a dictionary variable.
Excel VBA – Convert Range To Array – 2 Dimentional
December 22, 2024
Get Excel VBA Convert a Range to Array code in a Excel Workbook. And also write the array value to a worksheet range. Learn how to use of Resize & Transpose functions.
Open Text File – Read Write File Operations – VBA, Python, VBS, C, C++, DOS
Open Text File – VBA, VBS, Python, C, C++ Code snippets to Open ,Read, Write to text file. Import data from text file into any programming language.