将文本框数据保存在Excel工作表.xlsx中 [英] Save textbox data in Excel sheet .xlsx

问题描述

在下面的代码中我使用mydata base作为excel表，我只能在 excel sheet97-2003（.xls）上保存，但想要保存在 excel sheet2007（。 xlsx）

In the below code am using mydata base as excel sheet where i can able to save only on excel sheet97-2003(.xls), but want to save in excel sheet2007(.xlsx)

Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load


       TxtExamtime.Format = DateTimePickerFormat.Custom
       TxtExamtime.CustomFormat = "hh:mm tt"
       cn.ConnectionString = "provider=microsoft.jet.oledb.4.0; Data Source=C:\psave\New folder\save.xls;Extended Properties=Excel 8.0;"
       cn.Open()
       
       FillDataGridView1("select ID, [Family Name], [Given Name], Gender, DOB, [Street Name], [House Nr], Postcode, City FROM [Sheet1$]  WHERE ID IS NOT NULL AND [Family Name] IS NOT NULL AND [Given Name] IS NOT NULL AND Gender IS NOT NULL AND DOB IS NOT NULL AND [Street Name] IS NOT NULL AND [House Nr] IS NOT NULL AND Postcode IS NOT NULL AND City IS NOT NULL ")

       FillDataGridView2("select [Procedure Code], [Procedure name] from[Sheet2$] WHERE [Procedure Code] IS NOT NULL AND [Procedure name] IS NOT NULL ")
   End Sub

推荐答案

WHERE ID不为空且[姓名]不为空且[给定名称]为非NULL且性别不为空且DOB不为空且[街道名称]不为空且[House Nr]为IS非空和邮政编码不是空，城市是N. OT NULL）

FillDataGridView2（ 选择[程序代码]，[程序名称]来自[Sheet2

WHERE ID IS NOT NULL AND [Family Name] IS NOT NULL AND [Given Name] IS NOT NULL AND Gender IS NOT NULL AND DOB IS NOT NULL AND [Street Name] IS NOT NULL AND [House Nr] IS NOT NULL AND Postcode IS NOT NULL AND City IS NOT NULL ") FillDataGridView2("select [Procedure Code], [Procedure name] from[Sheet2

WHERE [程序代码] IS非空且[程序名称]不是空）
结束 Sub

WHERE [Procedure Code] IS NOT NULL AND [Procedure name] IS NOT NULL ") End Sub

您可以使用Microsoft Open XML SDK。请参阅本文中引用的过去的答案：如何从MS Visual中添加参考添加microsoft excel 15.0对象库Studio 2010 [ ^ ] 。



另请参阅此CodeProject文章：使用Open XML创建基本的Excel工作簿 [ ^ ]。

-SA

You can use Microsoft Open XML SDK. Please see my past answers referenced in this one: How to add microsoft excel 15.0 object library from Add Reference in MS Visual Studio 2010[^].

See also this CodeProject article: Creating basic Excel workbook with Open XML[^].

—SA

这篇关于将文本框数据保存在Excel工作表.xlsx中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！