Search found 2 matches

by ahmedsa
Tue Aug 02, 2022 1:39 am
Forum: General Discussion
Topic: How to modify python script to append data on file using sql server 2019?
Replies: 0
Views: 10163

How to modify python script to append data on file using sql server 2019?

0 I need to append data to excel file already exist from table students on SQL Server . So I need to append data when dbo.fn_FileExists(@FullFilePath)=1 Excel file already Created on D:\ExportExcel\dbo.students.xlsx with student IDs 1 and 2. studentid Name 1 ahmed 2 eslam student table with old data...
by ahmedsa
Tue May 03, 2022 11:10 pm
Forum: General Discussion
Topic: How to keep columns header on excel without change after export data to excel file?
Replies: 0
Views: 5268

How to keep columns header on excel without change after export data to excel file?

I work on sql server 2017 I run script depend on python language v 3.10 . I need to export data to excel fileStudentExport.xlsx already exist, and keep header without change after export. header of excel file StudentExport.xlsx before export data to it as below StudentId,StudentName after run script...

Go to advanced search