将worlsheet和csv与常用属性组合在一起 [英] Combine a worlsheet and a csv with common attributes

问题描述

我有一个excel表工作表（ source1 ）和一个csv（ source2 ）与第一个共同属性（字段）。我想加入他们。我完成了使用power-shell脚本在finalmerged.csv文件中导出数据。



问题在于我丢失了所有链接字段（计算字段）从excel文件（spurce1）：我导出数据值但不是链接格式。

我正在寻找一个自动解决方案，作为一个函数或脚本，因为这个任务必须经常进行。



是否有某种语言或更好的方法将两个文档组合在同一张表中（source1）？

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)?

推荐答案

据我所知，csv是一种ASCII格式文件。请参见此处 [ ^ ]



这意味着您只能复制Excel工作表中的值，而不是公式或链接或其他任何东西。



希望这有帮助。

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.

这篇关于将worlsheet和csv与常用属性组合在一起的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！