Click here to Skip to main content
15,867,756 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi ,

I have one excel table worksheet (source1) and a csv (source2) with some common attributes (fields) to the first one. I would like to join them. I accomplish it exporting the data in a finalmerged.csv file with a power-shell script.

The problem is doing that I lose all the link fields (calculated fields) from the excel file (spurce1): I export the data-value but not in link format.
I'm looking for an automatic solution , as a function or script because this task has to be done frequently.

Is there some language or a better way to combine both documents in the same sheet (source1)?
Posted
Updated 20-May-14 3:00am
v2
Comments
ZurdoDev 20-May-14 8:58am    
The easiest way is to import your csv into the Excel file using Excel.
Kinna-10626331 20-May-14 8:59am    
Yes but I'm searching an automatic way to combine the data , is a task that has to be done each two days, the csv changes.
Sergey Vaselenko 20-May-14 14:32pm    
You may use Excel formulas. Why not?
Sergey Vaselenko 20-May-14 11:21am    
You may combine the data in Excel using Excel formulas or in an external tool using Excel and CSV as data sources. What way is the best for you?

1 solution

As far as I know csv is an ASCII format file. See here[^]

That means you can only copy the "values" from an excel sheet, not formulas or links or anything else.

Hope this helps.
 
Share this answer
 
Comments
Kinna-10626331 20-May-14 9:47am    
I supposed that , what I'm asking is if there is some way to combine and generate an excel with the attributes instead to generate a csv. The plain text of the csv is ok , what I don't want to lose are the links in the excel file (source one ).
V. 20-May-14 12:23pm    
In that case you´ll need to use the api of Excel. There are many tutorials out there. You need to have excel installed on the pc that generates those files. Search for office automation or excel automation... Hope this helps.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900