将数据从文本框发送到excel page2或page3? [英] Send data from textboxes to excel page2 or page3 ?

问题描述

我想将文本框中的信息发送到excel，但是我想将数据发送到excel的第二页或第三页.我能怎么做?我编写了代码，但无法选择页面.

I want to send information from textboxes to excel but ı want to send data to second or third page in excel. How can I do? I write a code but I am unable to select page.

MExcel.Application Exceluygulama = new MExcel.Application();
MExcel.WorkbookExcelkitap=Exceluygulama.Workbooks.Add(Application.StartupPath + "\\raporlar\\customer.xls");
MExcel.Worksheet Excelsayfa = (MExcel.Worksheet)Exceluygulama.ActiveSheet;
Exceluygulama.Visible = true;

推荐答案

感谢您的回答ı尝试索引但不起作用，所以ı分割了excel pages.一页客户一页又一页喜欢that.so它正在工作.

thank you for your answer ı try index but not working so ı divide excel pages.one page customer one page another lıke that.so it is working.

工作表是一个集合，只需通过索引访问所需的表即可.还要记住，数组在Excel互操作中是基于1的.

Worksheets are a collection, just access the one you want via the index. Remember also that arrays are 1 based in Excel interop.

这篇关于将数据从文本框发送到excel page2或page3?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！