Saving DataGrid View to Excel and opening Excel to DataGrid View (.xls)

EDN Admin

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
hi,

For my code to open the datagrid view I got...
<div style="border-right:#7f9db9 1px solid;border-top:#7f9db9 1px solid;font-size:11px;overflow:auto;border-left:#7f9db9 1px solid;line-height:100%! important;border-bottom:#7f9db9 1px solid;font-family:Courier New;background-color:white
<table style="border-top-width:0px;border-left-width:0px;margin:2px 0px;width:99%;border-bottom:#eee 0px solid;border-collapse:collapse;background-color:#fff;border-right-width:0px" cellspacing=0 cellpadding=0>
<colgroup>
<col style="border-right:gray 1px solid;padding-right:5px;padding-left:10px;font-size:11px;vertical-align:top;width:5px;color:gray;font-family:Courier New;background-color:#eee;text-align:right
<col style="padding-left:10px;font-size:11px;border-bottom:#f7f7f7 1px solid;font-family:Courier New;white-space:nowrap
<tbody>
<tr>
<td><nobr>1</nobr></td>
<td><font style="font-size:11px Form6 </font><font style="color:red Form6</font><font style="font-size:11px  = </font><font style="color:blue new</font><font style="font-size:11px  Form6();  </font></td></tr>
<tr>
<td><nobr>2</nobr></td>
<td style="background-color:#f7f7f7             Form6.ShowDialog();  </td></tr>
<tr>
<td><nobr>3</nobr></td>
<td>            if (</font><font style="color:red Form6.FileOpened</font><font style="font-size:11px  == 1)  </font></td></tr>
<tr>
<td><nobr>4</nobr></td>
<td style="background-color:#f7f7f7             {  </td></tr>
<tr>
<td><nobr>5</nobr></td>
<td>                if (</font><font style="color:red Form6.Runner</font><font style="font-size:11px  == 1)  </font></td></tr>
<tr>
<td><nobr>6</nobr></td>
<td style="background-color:#f7f7f7                 {  </td></tr>
<tr>
<td><nobr>7</nobr></td>
<td>                    try  </td></tr>
<tr>
<td><nobr>8</nobr></td>
<td style="background-color:#f7f7f7                     {  </td></tr>
<tr>
<td><nobr>9</nobr></td>
<td>                        </font><font style="color:red this.dataGridView1.DataSource</font><font style="font-size:11px  = </font><font style="color:blue null</font><font style="font-size:11px ;  </font></td></tr>
<tr>
<td><nobr>10</nobr></td>
<td style="background-color:#f7f7f7  </td></tr>
<tr>
<td><nobr>11</nobr></td>
<td>                        this.dataGridView1.DataBindings.Clear();  </td></tr>
<tr>
<td><nobr>12</nobr></td>
<td style="background-color:#f7f7f7                         this.dataGridView1.ClearSelection();  </td></tr>
<tr>
<td><nobr>13</nobr></td>
<td> </td></tr>
<tr>
<td><nobr>14</nobr></td>
<td style="background-color:#f7f7f7                         this.dataGridView1.Rows.Clear();  </td></tr>
<tr>
<td><nobr>15</nobr></td>
<td>                        this.dataGridView1.Columns.Clear();  </td></tr>
<tr>
<td><nobr>16</nobr></td>
<td style="background-color:#f7f7f7  </td></tr>
<tr>
<td><nobr>17</nobr></td>
<td>                        OleDbConnection </font><font style="color:red cnn</font><font style="font-size:11px  = </font><font style="color:blue new</font><font style="font-size:11px  OleDbConnection("</font><font style="color:red Provider</font><font style="font-size:11px =</font><font style="color:blue Microsoft</font><font style="font-size:11px .Jet.OLEDB.4.0;Data </font><font style="color:red Source</font><font style="font-size:11px =</font><font style="color:blue " + FileName + "</font><font style="font-size:11px ;Extended </font><font style="color:red Properties</font><font style="font-size:11px ="Excel 8.0;</font><font style="color:red HDR</font><font style="font-size:11px =</font><font style="color:blue No</font><font style="font-size:11px ;</font><font style="color:red IMEX</font><font style="font-size:11px =</font><font style="color:blue 1</font><font style="font-size:11px ";");  </font></td></tr>
<tr>
<td><nobr>18</nobr></td>
<td style="background-color:#f7f7f7                         OleDbDataAdapter da;  </td></tr>
<tr>
<td><nobr>19</nobr></td>
<td>                        DataSet ds;  </td></tr>
<tr>
<td><nobr>20</nobr></td>
<td style="background-color:#f7f7f7  </td></tr>
<tr>
<td><nobr>21</nobr></td>
<td>                        </font><font style="color:red da</font><font style="font-size:11px  = </font><font style="color:blue new</font><font style="font-size:11px  OleDbDataAdapter("Select * from [" + SheetName1 + "]", cnn);  </font></td></tr>
<tr>
<td><nobr>22</nobr></td>
<td style="background-color:#f7f7f7                         </font><font style="color:red ds</font><font style="font-size:11px  = </font><font style="color:blue new</font><font style="font-size:11px  DataSet("TestExcel");  </font></td></tr>
<tr>
<td><nobr>23</nobr></td>
<td> </td></tr>
<tr>
<td><nobr>24</nobr></td>
<td style="background-color:#f7f7f7                         da.Fill(ds, "TestExcel");  </td></tr>
<tr>
<td><nobr>25</nobr></td>
<td>                        </font><font style="color:red dataGridView1.DataSource</font><font style="font-size:11px  = </font><font style="color:blue ds</font><font style="font-size:11px .Tables[0];  </font></td></tr>
<tr>
<td><nobr>26</nobr></td>
<td style="background-color:#f7f7f7                     }  </td></tr>
<tr>
<td><nobr>27</nobr></td>
<td>                    catch (Exception ex)  </td></tr>
<tr>
<td><nobr>28</nobr></td>
<td style="background-color:#f7f7f7                     {  </td></tr>
<tr>
<td><nobr>29</nobr></td>
<td>                        MessageBox.Show(ex.Message);  </td></tr>
<tr>
<td><nobr>30</nobr></td>
<td style="background-color:#f7f7f7                     }  </td></tr>
<tr>
<td><nobr>31</nobr></td>
<td>                    </font><font style="color:red Form6.Runner</font><font style="font-size:11px  = </font><font style="color:blue 0</font><font style="font-size:11px ;  </font></td></tr>
<tr>
<td><nobr>32</nobr></td>
<td style="background-color:#f7f7f7                 }  </td></tr>
<tr>
<td><nobr>33</nobr></td>
<td>                else  </td></tr>
<tr>
<td><nobr>34</nobr></td>
<td style="background-color:#f7f7f7                 {  </td></tr>
<tr>
<td><nobr>35</nobr></td>
<td>                }  </td></tr>
<tr>
<td><nobr>36</nobr></td>
<td style="background-color:#f7f7f7             } </td></tr></tbody></table>

considering the code above how would the code look to save to an excel file the way microsoft excel does...?

If you could help me out It would be a big help..

Thanks,

zBuster

View the full article
 
Back
Top