在 Pentaho 中将批量 .xlsx 文件转换为 .csv (UTF-8) [英] Convert bulk .xlsx files to .csv (UTF-8) in Pentaho

问题描述

我是 Pentaho 的新手.我正在尝试构建一个可以将一堆 .xlsx 文件转换为 .csv (utf-8) 的转换.我尝试了获取文件名和文本文件输出，但它将单个文件保存为 csv，该文件的内容是文件属性.我也尝试过 Microsoft Excel 输入和 Microsoft Excel 输出，但也没有奏效.

任何帮助将不胜感激.TIA！

解决方案

我准备了一个

此外，我从这个解决方案中学到了很多东西.

I am new to Pentaho. I am trying to build a transformation that can convert a bunch of .xlsx files to .csv (utf-8). I tried Get file Names and Text File Output, but it saves a single file as csv and the content of that file is the file properties. I also tried Microsoft Excel Input and Microsoft Excel Output and that did not work either.

Any help will be appreciated. TIA!

解决方案

I have prepare a SOLUTION for you. I have made my solution full dynamic. For that reason solution is combination of 6 (transformation & job). You only need to define following 2 things:-

1. Source folder location
2. Destination folder location

Others will work dynamically.

Also, I have learn a lot with this solution.

这篇关于在 Pentaho 中将批量 .xlsx 文件转换为 .csv (UTF-8)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！