如何使用.Net在Excel中插入新的列和列数据? [英] How to insert a new column and column data in excel using .Net?

问题描述

我有以下情况，
C:\ test.xls
test.xls具有以下列，
column1 column2 column3
1 a a a
2 b b b
3 c c c

现在，我需要以编程方式在test.xls中插入新列，如下所示，
column0 column1 column2 column3
1测试一个a
2测试b b b
3测试c c c c

任何人都可以使用C#在.Net中为我提供帮助.
感谢您的帮助.

I have following scenario,
C:\test.xls
test.xls have following columns,
column1 column2 column3
1 a a a
2 b b b
3 c c c

Now, I need to insert a new column in test.xls programatically as follow,
column0 column1 column2 column3
1 test a a a
2 test b b b
3 test c c c

Can anyone please help me in .Net using C#.
I appreciate help in this.

推荐答案

您尝试了什么?您尝试过Google吗? 第一个Google命中 [此处 [

What have you tried ? Did you try google ? First google hit[^]. I believe the Microsoft Tools for Office are what you''ll need to download. Seeing as it appears you have no access to Google, here[^] you go.

这篇关于如何使用.Net在Excel中插入新的列和列数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！