在excel表中插入记录 [英] Insert the records in excel sheet
问题描述
可以通过提供在excel文件中插入记录的方法来帮助任何人帮助
因为我创建了它所有它工作正常但我不知道如何在现有的excel文件中插入新记录。
例如
我的Excel工作表已填充前20行然后
i想要从21行开始在excel表中插入新记录
对此有任何想法，请发给我
谢谢
can any one help by providing the method inserting the records in excel file
because i created it all it works fine but i have no idea about how to insert new records in the existing excel file.
e.g
my excel sheet has filled first 20 rows and then
i want to insert the new records in the excel sheet starts from 21st row
is any idea about this, please send me
thanks
推荐答案
可以通过提供在excel文件中插入记录的方法来提供任何帮助
因为我创建了它所有它工作正常但我不知道如何在现有的excel文件中插入新记录。
can any one help by providing the method inserting the records in excel file
because i created it all it works fine but i have no idea about how to insert new records in the existing excel file.
如何将数据插入Excel工作表以及您使用的是哪个版本的Excel？从哪里获取数据？
How are you inserting the data into the excel sheet and which version of excel are you using? Also where is the data being taken from?
可以通过提供在excel文件中插入记录的方法来提供任何帮助
因为我创建它所有它工作正常但我不知道如何在现有的excel文件中插入新记录。
例如
我的excel表有填写前20行然后
i想要从21行开始在excel表中插入新记录
对此有任何想法，请发给我
谢谢
can any one help by providing the method inserting the records in excel file
because i created it all it works fine but i have no idea about how to insert new records in the existing excel file.
e.g
my excel sheet has filled first 20 rows and then
i want to insert the new records in the excel sheet starts from 21st row
is any idea about this, please send me
thanks
我想你必须打开excel文件并插入你想要的行..
它很难：
i think that you''ll have to open the excel file and insert the rows you want..
it aint that hard:
你好专家
i从sql server插入数据，我的excel版本是97
i告诉你我的程序是什么
i在我的excel表中有五个字段，我想通过编程每天在excel表中插入数据，首先我打开文件，插入数据，然后保存它下次我还想将数据插入到前一个结束行的同一个工作表中。如果我手动更改行和列名称然后它工作正常，但我不知道我如何插入数据，以便它自动选择最后一个空行和插入数据请发给我一些编码
我的编程是
Dim oExcel As Object
Dim oBook as Object
Dim oSheet as Object
设置oExcel = CreateObject（" Excel.Application"）
设置oBook = oExcel.Workbooks.Open（" C：\ varinder.xls"）
oExcel.UserControl = True
设置oSheet = oBook.Worksheets（1）
oSheet.Range（" A1"）。Value =" Last Name"
oSheet.Range（" B1"）。Value =" First Name"
oSheet.Range（" A1：B1"）。Font.Bold = True
oSheet.Range（" A5"）。Value =" delhi"
oSheet.Range（" B5"）。Value =" jammu"
保存工作簿并退出Excel
oBook.Sa veAs" C：\ varinder.xls"
oExcel.Quit
谢谢
hello expert
i am inserting the data from sql server and my excel version is 97
i tell you what is about my programe
i have five field in my excel sheet and i want to insert the data in excel sheet daily through programing, firstly i open the file and insert data and then save it next time i also want to insert the data into the same sheet continue from the previous end row . If i manually change the row and column name then it works fine but i have no idea how i insert the data so that it automatically choose the last empty row and insert data please send me some coding
My programing is
Dim oExcel As Object
Dim oBook As Object
Dim oSheet As Object
Set oExcel = CreateObject("Excel.Application")
Set oBook = oExcel.Workbooks.Open("C:\varinder.xls")
oExcel.UserControl = True
Set oSheet = oBook.Worksheets(1)
oSheet.Range("A1").Value = "Last Name"
oSheet.Range("B1").Value = "First Name"
oSheet.Range("A1:B1").Font.Bold = True
oSheet.Range("A5").Value = "delhi"
oSheet.Range("B5").Value = "jammu"
Save the Workbook and Quit Excel
oBook.SaveAs "C:\varinder.xls"
oExcel.Quit
thanks
如何将数据插入Excel工作表以及您使用的是哪个版本的Excel？还从哪里获取数据？
How are you inserting the data into the excel sheet and which version of excel are you using? Also where is the data being taken from?
这篇关于在excel表中插入记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
