importing data from excel

deepblue

hello,

I want to import data from a datasheet from excel. Can you help me and give me an exemple of a code that does this!!!!

thank you!!!

Styvie

Save as CSV from Excel and Use a Dataport.

Create new dataport. Pick your table. Add fields to be imported..

If you need to read from an Excel worksheet without this step, you need to use Excel Automation. This is pretty simple as well. Check Table 370 for examples of writing to Excel. Reading is identical.

johnson_alonso

You can see this below topic:

http://www.mibuso.com/forum/viewtopic.php?t=10544 or

I think you will use form ID # 8600 and 8601 in the object designer. to activifying both, just click run button.


rgds,
Johnson ALonso

johnson_alonso

Hey,

I think there is another way if your file from excel, that is by using save your file in the CSV extension file and then import the file using dataport feature.


rgds,
Johnson

kriki

Styvie wrote:

Save as CSV from Excel and Use a Dataport.

Better save it as tab-seperated, you will have less problems.
Dataport: use the following properties
"FieldStartDelimiter","FieldEndDelimiter":<None>
"FieldSeparator":<TAB>

frankmortensen

An example of importing data from an excel spread sheet can be found in Report 81 "Import Budget from Excel".

/Frank

Styvie

True...

//Better save it as tab-seperated, you will have less problems.
//Dataport: use the following properties
//"FieldStartDelimiter","FieldEndDelimiter":<None>
//"FieldSeparator":<TAB>

deepblue

thanks Kriki!!!

it works well!!!!