Work on Excel Sheets (Part I)
- Integrated Circuits -
- An Online Book -
Integrated Circuits                                                                                   http://www.globalsino.com/ICs/

Chapter/Index: Introduction | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | Appendix

=================================================================================

============================================

Output:

============================================

Create and Excel file and sheets: code:

Output:

============================================

Read the value of an excel file and its active sheet: code:

Input:

Output (the output can be only the formula if there is a calculation with formula):

Output (the output is real numbers if they are numbers):

============================

Read the value of an excel file and its active sheet: code:

Input and output:
Are the same as the ones above.

============================================

Merge cells in an excel file and then unmerge the cells: code:

Input:

Output after merging the cells:

Output after unmerging the cells (note: the previous data in the merged cells is lost):

============================================

Insert rows in excel : code:

Input:

Output (note that there is an accumulation of insert rows if one is inserted many times):

============================================

Delete rows in excel : code:

Input:

Output:

============================================

Insert columns in excel : code:

Input:

Output:

============================================

Delete columns in excel : code:

Input:

Output:

============================================

Shift/move columns and rows in an range in excel: code:

Input:

Output:

============================================

Write data into a new Excel sheet: code:

Output:

=================================================================================