将worlsheet和csv与常用属性组合在一起

本文介绍了将worlsheet和csv与常用属性组合在一起的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有一个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.