 |  |  |  |  |  |  |  |
transfer contends from database table to excel
Please support our C# advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!
 |
•
•
Join Date: Dec 2007
Posts: 200
Reputation: 
Solved Threads: 11
Posting Whiz in Training
hi,
i want to transfer the contends of a table from database to excel. can i declare a excel sheet in c#
i want to transfer the contends of a table from database to excel. can i declare a excel sheet in c#
Have an ask of google. Google knows the answers
Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.
•
•
Join Date: Dec 2007
Posts: 200
Reputation:
Solved Threads: 11
Posting Whiz in Training
done dat. am able to do it now. but i want the column names also. Is that possible?
f you need to putput it, and keep the names, put the names into an array you can output as a header line.
Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.
•
•
Join Date: Dec 2007
Posts: 200
Reputation:
Solved Threads: 11
Posting Whiz in Training
Also if i want to save it somewhere of my wish what would the code be like. i have defined a workbook also populated the values. now while saving it is saving in the same place where project is created. i want to save it in some other place. my code is
wb.SaveAs(FileName,Excel.XlFileFormat.xlWorkbookNormal,
null,null,false,false,Excel.XlSaveAsAccessMode.xlShared,
false,false,null,null,null);
what changes do i make?
wb.SaveAs(FileName,Excel.XlFileFormat.xlWorkbookNormal,
null,null,false,false,Excel.XlSaveAsAccessMode.xlShared,
false,false,null,null,null);
what changes do i make?
Change the filename.. or is there some hidden part to that question
Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.
•
•
Join Date: Dec 2007
Posts: 200
Reputation:
Solved Threads: 11
Posting Whiz in Training
C# Syntax (Toggle Plain Text)
this is my code ? can you suggest any solution
Now you really are being stupid
the contents of "Filename" has to be what you wanted..
the contents of "Filename" has to be what you wanted..
Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.
•
•
Join Date: Dec 2007
Posts: 200
Reputation:
Solved Threads: 11
Posting Whiz in Training
The contents of "Filename" that i can provide is just the any name for the file, not like "C:\....". it is getting saved in my documents folder.
Please give a proper solution
Please give a proper solution
Sorry, but you are being stupid,
Put the path in your filename, and it will be saved where you tell it..... If you dont it would be saved in whats the "current directory"
Put the path in your filename, and it will be saved where you tell it..... If you dont it would be saved in whats the "current directory"
Did I just hear "You gotta help us, Doc. We've tried nothin' and we're all out of ideas" ? Is this you? Dont let this be you! I will put in as much effort as you seem to.
|
Other Threads in the C# Forum
- Previous Thread: converting VB to C sharp for Quality Center
- Next Thread: Loading Database data into Labels for viewing?
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest C# Posts
- Today's Posts
- Unanswered Threads
.net access algorithm app application array bitmap box c# check checkbox client color combo combobox concurrency control conversion csharp custom cyclethruopenforms data database datagrid datagridview dataset datatable date/time datetime degrees dll draganddrop drawing enabled encryption enum excel file filename finalyearproject foreach form format forms function gdi+ getoutlookcontactusinfcsvfile globalization gtk image input install installer java keypress label list localization math microsoftc#visualexpress mono mouseclick mysql operator panel path photoshop picturebox pixelinversion post programming radians regex remoting richtextbox save server sleep socket sql sql-server statistics string table text textbox thread time timer timespan update usercontrol users validate validation visualstudio webbrowser winforms wpf xml