保存前如何在xls电子表格中添加行 [英] How do add a row to a xls spreadsheet before saving it

问题描述

我如何在现有/打开的电子表格中添加一行.我不想每次都创建一个新的电子表格.我已经尝试过此代码:

how i add a row to an existing/opened spreadsheet. i don''t want to create a new spreadsheet everytime. i have tried this code:

oSheet.range ("A2").value = txtOrderNumber.text
oSheet.range("B2").value = txtQuantity.text
'Save the workbook
oBook.saveas(fileName)
oSheet = Nothing

这里的想法是一次打开电子表格，并向其中添加信息直到一天结束.请帮忙！

谢谢

The idea here is to open a spreadsheet once and add information to it until end of day. Please help!!

Thanks

推荐答案

好的goole是你最好的老师，所以这里的链接对你有帮助


http://msdn.microsoft.com/en-us/library/aa168292％28v = office.11​​％29.aspx [ ^ ]

Well goole is your best Teacher so here is a link which would help you


http://msdn.microsoft.com/en-us/library/aa168292%28v=office.11%29.aspx[^]

这篇关于保存前如何在xls电子表格中添加行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！