问题描述
利用Ｃ＃画一个Winform框，浏览电脑中的文件，将读取到的文件展示在文本框中，并且将读取到的txt内容写入到Excel表格中，如何写入。
解决方案
解决方案二：
两列之间用t两行之间用n换行用r最后最后后最改成.xls
解决方案三：
excel是一个xml，你写xml就可以了，下面是一个excel文件的例子，把这段xml保存为xls文件<?xmlversion="1.0"?><?mso-applicationprogid="Excel.Sheet"?><Workbookxmlns="urn:schemas-microsoft-com:office:spreadsheet"xmlns:o="urn:schemas-microsoft-com:office:office"xmlns:x="urn:schemas-microsoft-com:office:excel"xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"xmlns:html="http://www.w3.org/TR/REC-html40"><DocumentPropertiesxmlns="urn:schemas-microsoft-com:office:office"><Created>2006-09-16T00:00:00Z</Created><LastSaved>2012-07-30T08:22:52Z</LastSaved><Version>14.00</Version></DocumentProperties><OfficeDocumentSettingsxmlns="urn:schemas-microsoft-com:office:office"><AllowPNG/><RemovePersonalInformation/></OfficeDocumentSettings><ExcelWorkbookxmlns="urn:schemas-microsoft-com:office:excel"><WindowHeight>8010</WindowHeight><WindowWidth>14805</WindowWidth><WindowTopX>240</WindowTopX><WindowTopY>105</WindowTopY><ProtectStructure>False</ProtectStructure><ProtectWindows>False</ProtectWindows></ExcelWorkbook><Styles><Styless:ID="m96984576"><Alignmentss:Horizontal="Center"ss:Vertical="Center"/><Borders><Borderss:Position="Bottom"ss:LineStyle="Continuous"ss:Weight="1"/><Borderss:Position="Left"ss:LineStyle="Continuous"ss:Weight="1"/><Borderss:Position="Right"ss:LineStyle="Continuous"ss:Weight="1"/><Borderss:Position="Top"ss:LineStyle="Continuous"ss:Weight="1"/></Borders><Fontss:FontName="宋体"x:CharSet="134"ss:Size="28"ss:Color="#000000"ss:Bold="1"/><Interiorss:Color="#FFFFFF"ss:Pattern="Solid"/></Style><Styless:ID="m96984596"><Alignmentss:Horizontal="Right"ss:Vertical="Center"/><Borders><Borderss:Position="Bottom"ss:LineStyle="Continuous"ss:Weight="1"/><Borderss:Position="Left"ss:LineStyle="Continuous"ss:Weight="1"/><Borderss:Position="Right"ss:LineStyle="Continuous"ss:Weight="1"/><Borderss:Position="Top"ss:LineStyle="Continuous"ss:Weight="1"/></Borders><Fontss:FontName="宋体"x:CharSet="134"ss:Size="11"ss:Color="#000000"ss:Bold="1"/><Interiorss:Color="#DAEEF3"ss:Pattern="Solid"/><NumberFormatss:Format="ShortDate"/></Style><Styless:ID="Default"ss:Name="Normal"><Alignmentss:Vertical="Bottom"/><Borders/><Fontss:FontName="宋体"x:CharSet="134"ss:Size="11"ss:Color="#000000"/><Interior/><NumberFormat/><Protection/></Style><Styless:ID="s16"><Alignmentss:Horizontal="Center"ss:Vertical="Center"/></Style><Styless:ID="s22"><Alignmentss:Horizontal="Center"ss:Vertical="Center"/><Borders><Borderss:Position="Bottom"ss:LineStyle="Continuous"ss:Weight="1"/><Borderss:Position="Left"ss:LineStyle="Continuous"ss:Weight="1"/><Borderss:Position="Right"ss:LineStyle="Continuous"ss:Weight="1"/><Borderss:Position="Top"ss:LineStyle="Continuous"ss:Weight="1"/></Borders></Style><Styless:ID="s93"><Alignmentss:Horizontal="Center"ss:Vertical="Center"/><Fontss:FontName="宋体"x:CharSet="134"ss:Size="28"ss:Color="#000000"ss:Bold="1"/><Interiorss:Color="#366092"ss:Pattern="Solid"/></Style><Styless:ID="s106"><Alignmentss:Horizontal="Center"ss:Vertical="Center"/><NumberFormatss:Format="ShortDate"/></Style><Styless:ID="s136"><Alignmentss:Horizontal="Center"ss:Vertical="Bottom"/><Interiorss:Color="#00B050"ss:Pattern="Solid"/></Style><Styless:ID="s138"><Interiorss:Color="#00B050"ss:Pattern="Solid"/></Style><Styless:ID="s139"><Alignmentss:Vertical="Bottom"/><Interiorss:Color="#00B050"ss:Pattern="Solid"/></Style><Styless:ID="s152"><Alignmentss:Horizontal="Center"ss:Vertical="Center"/><Borders><Borderss:Position="Bottom"ss:LineStyle="Continuous"ss:Weight="1"/><Borderss:Position="Left"ss:LineStyle="Continuous"ss:Weight="1"/><Borderss:Position="Right"ss:LineStyle="Continuous"ss:Weight="1"/><Borderss:Position="Top"ss:LineStyle="Continuous"ss:Weight="1"/></Borders><Fontss:FontName="宋体"x:CharSet="134"ss:Size="12"ss:Bold="1"/><Interiorss:Color="#92D050"ss:Pattern="Solid"/></Style><Styless:ID="s158"><Alignmentss:Horizontal="Center"ss:Vertical="Center"/><NumberFormatss:Format="ShortDate"/></Style><Styless:ID="s160"><Alignmentss:Horizontal="Left"ss:Vertical="Center"/><Borders><Borderss:Position="Bottom"ss:LineStyle="Continuous"ss:Weight="1"/><Borderss:Position="Left"ss:LineStyle="Continuous"ss:Weight="1"/><Borderss:Position="Right"ss:LineStyle="Continuous"ss:Weight="1"/><Borderss:Position="Top"ss:LineStyle="Continuous"ss:Weight="1"/></Borders><Interiorss:Color="#DAEEF3"ss:Pattern="Solid"/></Style><Styless:ID="s161"><Alignmentss:Horizontal="Right"ss:Vertical="Center"/><Borders><Borderss:Position="Bottom"ss:LineStyle="Continuous"ss:Weight="1"/><Borderss:Position="Left"ss:LineStyle="Continuous"ss:Weight="1"/><Borderss:Position="Right"ss:LineStyle="Continuous"ss:Weight="1"/><Borderss:Position="Top"ss:LineStyle="Continuous"ss:Weight="1"/></Borders><Fontss:FontName="宋体"x:CharSet="134"ss:Size="11"ss:Color="#000000"ss:Bold="1"/><Interiorss:Color="#92CDDC"ss:Pattern="Solid"/></Style></Styles><Worksheetss:Name="卫星药房-收支明细"><Tabless:ExpandedColumnCount="5"ss:ExpandedRowCount="32"x:FullColumns="1"x:FullRows="1"ss:DefaultColumnWidth="54"ss:DefaultRowHeight="15.5"><Columnss:AutoFitWidth="0"ss:Width="236"/><Columnss:AutoFitWidth="0"ss:Width="236"/><Columnss:AutoFitWidth="0"ss:Width="236"/><Columnss:AutoFitWidth="0"ss:Width="236"/><Columnss:AutoFitWidth="0"ss:Width="236"/><Rowss:AutoFitHeight="0"ss:Height="57.75"><Cellss:MergeAcross="4"ss:StyleID="m96984576"><Datass:Type="String">卫星药房-收支明细</Data></Cell></Row><Rowss:AutoFitHeight="0"ss:Height="15.5"><Cellss:MergeAcross="4"ss:StyleID="m96984596"><Datass:Type="String">15-11-2下午4:59(创建人:管理员)</Data></Cell></Row><Row><Cellss:Index="1"ss:StyleID="s161"><Datass:Type="String">药房</Data></Cell><Cellss:StyleID="s160"><Datass:Type="String">卫星药房</Data></Cell><Cellss:StyleID="s161"><Datass:Type="String">制表人</Data></Cell><Cellss:MergeAcross="1"ss:StyleID="s160"><Datass:Type="String">张琪</Data></Cell></Row><Row><Cellss:Index="1"ss:StyleID="s161"><Datass:Type="String">结存日期</Data></Cell><Cellss:MergeAcross="3"ss:StyleID="s160"><Datass:Type="String">2015-04-20</Data></Cell></Row><Rowss:AutoFitHeight="0"ss:Height="30"><Cellss:StyleID="s152"><Datass:Type="String">类型</Data></Cell><Cellss:StyleID="s152"><Datass:Type="String">名称</Data></Cell><Cellss:StyleID="s152"><Datass:Type="String">零售金额</Data></Cell><Cellss:StyleID="s152"><Datass:Type="String">进价金额</Data></Cell><Cellss:StyleID="s152"><Datass:Type="String">零售进价差额</Data></Cell></Row><Rowss:AutoFitHeight="0"><Cellss:Index="1"ss:StyleID="s22"><Datass:Type="String">收入</Data></Cell><Cellss:Index="2"ss:StyleID="s22"><Datass:Type="String">上期结存</Data></Cell><Cellss:Index="3"ss:StyleID="s22"><Datass:Type="String">187,628.93</Data></Cell><Cellss:Index="4"ss:StyleID="s22"><Datass:Type="String">161,777.54</Data></Cell><Cellss:Index="5"ss:StyleID="s22"><Datass:Type="String">25,851.39</Data></Cell></Row><Rowss:AutoFitHeight="0"><Cellss:Index="1"ss:StyleID="s22"><Datass:Type="String">收入</Data></Cell><Cellss:Index="2"ss:StyleID="s22"><Datass:Type="String">药房拨入</Data></Cell><Cellss:Index="3"ss:StyleID="s22"><Datass:Type="String">35,259.38</Data></Cell><Cellss:Index="4"ss:StyleID="s22"><Datass:Type="String">30,685.61</Data></Cell><Cellss:Index="5"ss:StyleID="s22"><Datass:Type="String">4,573.77</Data></Cell></Row></Table><WorksheetOptionsxmlns="urn:schemas-microsoft-com:office:excel"><PageSetup><Layoutx:Orientation="Landscape"/><Headerx:Margin="0.3"/><Footerx:Margin="0.3"/><PageMarginsx:Bottom="0.75"x:Left="0.7"x:Right="0.7"x:Top="0.75"/></PageSetup><Print><ValidPrinterInfo/><PaperSizeIndex>9</PaperSizeIndex><HorizontalResolution>600</HorizontalResolution><VerticalResolution>600</VerticalResolution></Print><Selected/><Panes><Pane><Number>3</Number><ActiveRow>10</ActiveRow><ActiveCol>3</ActiveCol></Pane></Panes><ProtectObjects>False</ProtectObjects><ProtectScenarios>False</ProtectScenarios></WorksheetOptions></Worksheet></Workbook>
解决方案四：
建议你了解一下NPOI或ClosedXML这两个插件都可以非常方便的导出Excel
解决方案五：
已经用过了，但是还是读不出来，那个npoi实在是没接触过。。。不知道有没有什么更好的方法。。