http://www.vbex.ru/index.php?action=history&feed=atom&title=VB.Net%2FWindows_System%2FExcel
VB.Net/Windows System/Excel - История изменений
2026-04-05T05:43:51Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.vbex.ru/index.php?title=VB.Net/Windows_System/Excel&diff=590&oldid=prev
в 16:40, 26 мая 2010
2010-05-26T16:40:06Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 16:40, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://www.vbex.ru/index.php?title=VB.Net/Windows_System/Excel&diff=591&oldid=prev
Admin: 1 версия
2010-05-26T12:44:36Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Load Excel to edit xlsx file==<br />
<br />
<br />
<br />
<source lang="vbnet"> <br />
<br />
Module Module1<br />
Sub Main()<br />
Dim file As String = "Data.xlsx"<br />
Try<br />
Dim row, col, finalRow, finalCol As Integer<br />
Dim xl = CreateObject("Excel.application")<br />
xl.Workbooks.Open(file)<br />
xl.Worksheets("Sheet1").activate()<br />
finalRow = xl.ActiveSheet.UsedRange.Rows.Count<br />
finalCol = xl.ActiveSheet.UsedRange.Columns.Count<br />
Dim vals(finalRow, finalCol) As String<br />
For row = 1 To finalRow<br />
For col = 1 To finalCol<br />
vals(row, col) = _<br />
Str(xl.ActiveSheet.Cells(row, col).Value)<br />
Console.WriteLine(row)<br />
Console.WriteLine(col)<br />
Console.WriteLine(vals(row, col))<br />
Next col<br />
Next row<br />
xl.Workbooks.Close()<br />
xl = Nothing<br />
Catch ex As Exception<br />
MsgBox("Unable to read spreadsheet")<br />
End Try<br />
End Sub<br />
End Module<br />
<br />
<br />
</source></div>
Admin