Excel Files
-
Hello Code Project I'm developing an app and i'm having some issues so i hope somebody helps me out I have a "form" in that form i made a search to a table from a database named "Vehicle_Information" So i filter the results through checkboxes example ◘ID ◘GPS ID ◘NAME .... So when the user checks ◘ID, the column of "ID" appears on the Data Grid i can create an excel file from a datagrid but when the data is created ALL THE COLUMNS AND DATA APPEARS ON THE EXCEL FILE! and i don't want that , i just want the columns the user selected. My Question is: HOW CAN I SEND TO AN EXCEL FILE A GROUP OF SELECTED COLUMNS OF DATA FROM A DATAGRIDVIEW???? I've tryed so hard :/ Thanks.
-
Hello Code Project I'm developing an app and i'm having some issues so i hope somebody helps me out I have a "form" in that form i made a search to a table from a database named "Vehicle_Information" So i filter the results through checkboxes example ◘ID ◘GPS ID ◘NAME .... So when the user checks ◘ID, the column of "ID" appears on the Data Grid i can create an excel file from a datagrid but when the data is created ALL THE COLUMNS AND DATA APPEARS ON THE EXCEL FILE! and i don't want that , i just want the columns the user selected. My Question is: HOW CAN I SEND TO AN EXCEL FILE A GROUP OF SELECTED COLUMNS OF DATA FROM A DATAGRIDVIEW???? I've tryed so hard :/ Thanks.
-
Hello Code Project I'm developing an app and i'm having some issues so i hope somebody helps me out I have a "form" in that form i made a search to a table from a database named "Vehicle_Information" So i filter the results through checkboxes example ◘ID ◘GPS ID ◘NAME .... So when the user checks ◘ID, the column of "ID" appears on the Data Grid i can create an excel file from a datagrid but when the data is created ALL THE COLUMNS AND DATA APPEARS ON THE EXCEL FILE! and i don't want that , i just want the columns the user selected. My Question is: HOW CAN I SEND TO AN EXCEL FILE A GROUP OF SELECTED COLUMNS OF DATA FROM A DATAGRIDVIEW???? I've tryed so hard :/ Thanks.
Hey Excel object model is a very powerfull object in the .net family. You can easly select Which values to export usind the Range property of the class. For instance if you wanted to export say cell A1 to A12 you can set the Excel.Range("A1 A12") when exporting hope this helps
-
Hey Excel object model is a very powerfull object in the .net family. You can easly select Which values to export usind the Range property of the class. For instance if you wanted to export say cell A1 to A12 you can set the Excel.Range("A1 A12") when exporting hope this helps
