But there is also other ways to get dictionary from Excel "live". So every time you change something in Excel file it will be synchronized by AMODIT. To achieve it you have to put your Excel file in a folder on server. Then you create "external dictionary" using Office driver. You just need to use proper connection string refering to Office driver and supplying Excel file's path (see picture below).
Then you need to place sheet name as table name with "[" at beginning and "$]" at end. You can refer to column names and their names have to be stored in first row of the sheet.
If you do it right AMODIT will read this file once a day and will synchronize dictionary. Quite easy and simple :)
No comments:
Post a Comment