Microsoft.Office.Interop.Excel-* .csv文件打开 [英] Microsoft.Office.Interop.Excel - *.csv file opening

问题描述

我创建了*.csv文件，但是当我使用Microsoft.Office.Interop.Excel打开文件时，由于忽略了定界符;，因此格式错误.

I create *.csv file, but when I open it using Microsoft.Office.Interop.Excel, it's formatting is wrong, because of ignoring the delimiter ;.

excelWorkbook = excelApp.Workbooks.Open(workbookPath, 0,
                    false,5,"","", false, Excel.XlPlatform.xlWindows, "", true,
                    false, 0, true, false, false);

我应该更改Workbooks.Open的哪个参数?

Which parameter of Workbooks.Open should I change?

谢谢您的建议.

推荐答案

定界符参数，第9个.将""更改为";". 有关更多信息，请检查

The delimiter argument, which is the 9th one. Change "" to ";". For more info, check msdn

这篇关于Microsoft.Office.Interop.Excel-* .csv文件打开的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！