Tips&Tricks: Excel Automation

bonsai

Any idea how to edit existing excel?

geronimo

bonsai wrote:

Any idea how to edit existing excel?

check the function Procedure OpenExistingXlsWorkbook in the first post of this topic. Here an existing excel is opened.

Sog

Another tip for importing trough the excel buffer.
When importing textfields that may never be parsed as decimal you can check if the cel property is text with this "extension" for the Excel buffer:
Function Readsheet

Replace
IF IsDecimal("Cell Value as Text") THEN
with
IF IsDecimal("Cell Value as Text") AND (FORMAT(XlWrkSht.Range(xlColID+xlRowID).NumberFormat) <> '@') THEN

Numberformat has for the file I've imported the values Standard (for non-formatted cells), @ (for text cells) and (jj/mm/dd for datefields (depends on the dateformat used)).