HTML to Excel using Javascript and Excel to HTML using VBA

This two part article consists of: Part A - Converting HTML to Excel using Javascript Part B - Exporting Excel to HTML using VBA HTML to Excel using javascript Let’s first take a look at tables in html. Data tables are typically stored in HTML using the <table> tag. Such a table will typically consist of one or more rows (<tr> tag) with each row having one or more cells (<td> tag). To read a ...

Continue Reading

HTML to Excel using Javascript and Excel to HTML using VBA

Excel Color Palette and Color Index change using VBA

Posted on 20 August 2009

Excel Color Palette and Color Index change using VBA
Excel Color Palette has an index of 56 colors which can be modified using VBA. Each color in the palette is associated with a unique value in the index that can be changed programatically. At times it is useful to know the relative positioning of the various colors within this index as well as how various versions of Excel treat colors. This is the first in the series of articles that will expore this further. How to generate Excel Color Index ...
Continue Reading

Comments (19)

Excel 2007

Posted on 25 July 2009

Excel 2007
Excel 2007 finally happened to me. Its not that I've never though of moving to Excel 2007 from the 2003 avatar of Excel, but you see, yours truly has never been accused of being an early adopter in the past, no sir never, and I've got a duty to protect that reputation. I bought my first phone after it had been on the market for a few years, bought my first car after it had been on road for a ...
Continue Reading

Comments (10)

Hide Error Value and Error Indicators in Excel

Posted on 26 June 2009

Hide Error Value and Error Indicators in Excel
To hide error value and error indicators in Excel you can use any of the following means: Hide error values using conditional formatting Hide errors indicators by turning off background error Hide error values by using IF(ISERROR()) function Hide error using a custom VBA function Let's take a closer look at each type of error handling method. Hide error values using conditional formatting Click on the cell that contains an error value. From the menu, select 'Format' -> 'Conditional Formatting'. ...
Continue Reading

Comments (3)

Read Write to File, Excel Workbook, Access using Javascript & SQL

Posted on 22 June 2009

Read Write to File, Excel Workbook, Access using Javascript & SQL
Read Write to File, Excel Workbook, Access using Javascript and SQL Javascript when used with ADO* and SQL can read write from data sources such as a file, Excel or an Access database. (* ADO = ActiveX Data Object). Since this technique relies on the use of ADO, a bit about ADO before we begin to help you understand how this works. According to wiki, Microsoft's ActiveX Data Objects (ADO) is a set of Component Object Model (COM) objects for accessing ...
Continue Reading

Comments (19)

How to make your comments in Excel more useful

Posted on 24 March 2009

How to make your comments in Excel more useful
Did you know that there are many other ways in which you can add comments to your excel spreadsheet. Here are a couple of ways:- Fill Effects You can insert a comment by simply using the Right Click -> ‘Insert Comment’ options. You can then double click on the comment’s border and click on ‘Color and Lines’ tab in the pop-up. In the drop-down for the ‘Colors’ section, ‘choose Fill Effects’. Now select ...
Continue Reading

Comments     



Subscribe

Keep up with the latest stories - Delivered right to your inbox
feedburner

Translate

English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel