Importing from excel

[tommyj77pl]

Hi
I have a problem...
I look for some way to read excel cells then process it in progress code and send information back to the same excel spread sheet. Do You know if this is possible running progress on linux server ?

 

[Max Viskov]

Hi
Honestly, I am not familiar with any tools which allow to read excel directly on Linux (I am not saying they do not exist)
What I can suggest is the following:
- In order to read file: to export Excel file to CSV, and then read it from progress
- In order to write file: on Linux you can generate an xml file with certain structure and extension XLS, which will be opened natively by excel.

Regards

____________________________________
Max Viskov
Senior Consultant, Implementation Services
MFG/PRO Toronto User Group Board Member
32Soft Inc., an Official QAD Subcontractor
Need to extract MFG/PRO documents to Excel and Acrobat?
Free Tools at http://www.32soft.com/site/modules/xt_conteudo/index.php?id=12[FONT=&quot][/FONT]

 

[tommyj77pl]

Thanx for reply
can you tell me how can I read file from progress?

 

[Max Viskov]

Hi
Something like this, if your input file has two fields, delimited with "," for example:

def temp-table xtable
field xfield1 as <something>
field xfield2 as <something>
.


input from <file_name>.
REPEAT TRANSACTION:
create xtable.
import
xfield1
xfield2
.
end .
input close .



Regards


____________________________________
Max Viskov
Senior Consultant, Implementation Services
MFG/PRO Toronto User Group Board Member
32Soft Inc., an Official QAD Subcontractor
Have an MFG/PRO question?
I will answer your questions for free at http://www.32soft.com/site/modules/newbb/viewforum.php?forum=5

 

[tommyj77pl]

How the progress knows what I used to sepeate columns?
I have created csv file with "," as the seperator but it seems to me like progress seperate the column using space or tab.
Regards
Tom

 

[tommyj77pl]

Import delimiter "<seperator>"...
I should read help first before I post

 

[tommyj77pl]

I think this will be last question ...
I have generated excel file but now I would like to be able to run this . Only problem is that Progress run on unix and users run the reports on windows platform... is it any chance to do that?
BR
Tom

 

[Max Viskov]

Hi
You have several options here:
1. To send a file to the user by email. You defines a special printer device in MFG/PRO, which calls a special unix script sending a file to the user who runs the report.
2. Create a shared drive, which will be shared between Unix and Windows machine (for example using Samba). The files will be saved there from Unix, and picked-up from Windows.
3. You can download our free-to-try tool, which extracts data from MFG/PRO directly into native Excel on your desktop. You can get it here: http://www.32soft.com/site/modules/PDdownloads/viewcat.php?cid=1

Good luck
____________________________________
Max Viskov
Senior Consultant, Implementation Services
MFG/PRO Toronto User Group Board Member
32Soft Inc., an Official QAD Subcontractor
Need GL Report Writer reports on the Web/Excel?
Check 32WebReport at http://www.32soft.com/site/modules/xt_conteudo/index.php?id=9http://www.32soft.com/site/modules/xt_conteudo/index.php?id=9