importing data from excel

deepblue · 2006-03-16

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 · 2006-03-16

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 · 2006-03-16

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 · 2006-03-16

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 · 2006-03-16

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 · 2006-03-16

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

/Frank

Styvie · 2006-03-16

True...

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

deepblue · 2006-03-16

thanks Kriki!!!

it works well!!!!

importing data from excel

Answers

Categories