Microsoft is providing this information as a convenience to you. Note: This response contains a reference to a third party World Wide Web site. More details you can refer to this document. M_objBook.Close(false, m_objOpt, m_objOpt) M_objOpt, m_objOpt, m_objOpt, m_objOpt, .XlSaveAsAccessMode.xlNoChange, m_objOpt, m_objOpt, M_objBook.SaveAs(m_strSampleFolder + "Book5.xls", .XlFileFormat.xlWorkbookNormal, Save the text file in the typical workbook format and quit Excel. XlTextParsingType.xlDelimited, .XlTextQualifier.xlTextQualifierDoubleQuote,įalse, true, false, false, false, false, m_objOpt, m_objOpt, M_objBooks.OpenText(m_strSampleFolder + "Book5.txt", .XlPlatform.xlWindows, 1, M_objBooks = (.Workbooks)m_objExcel.Workbooks Private void button1_Click(object sender, EventArgs e) Private object m_strSampleFolder = "C:\\Users\\danielzh\\Desktop\\" Then, you can use OpenText() method to open the text file and use SaveAs() method to save it as xls file. You can create a delimited text file that excel can parse into rows and columns.įirst, you can add the to the project by following the steps.ġ.Right click the project> Add> Reference>Choose the NuGet BaseConnectionLibrary for database connections. My MSDN profile but will not answer coding question on either. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via Please remember to mark the replies as answers if they help and unmarked them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Sl.ImportText("ImportTextDelimited.txt", "A1", tio) Sl.RenameWorksheet(SLDocument.DefaultFirstSheetName, "Delimited") Namespace SpreadSheetLightImportTextFilesConsoleApp As requirements become complete you will also need Microsoft DocumentFormat.OpenXml version 2.5 as a reference in this project which is also free. Simple example using tab delimited file with the data you provided. Note that this is ignoring the complexities of CSV parsing such as quotes and whatnot but you get the idea.Īlternate solution for creating. Should probably verify that the line had the min fields we need. Get the fields from the line - assuming CSV here The most simplistic parsing might look something like this for a CSV file. However in your for loop you're referencing the lines themselves but each line is a separate row right? Within the text file how are you distinguishingīetween name, age and nationality? Is this is a CSV file and therefore comma separated? You need to parse each line to get the column values. So if you have 3 lines then you'd have 3 values in this array. I don't know the Excel model that well but do indice start at 1? You should probably verify.Īlso your `inputLines` are the lines of the file. The second index is fixed (eitherġ, 2 or 3). The first value is the row and the second value is the column so your for loop should be enumerating the lines of the input file and incrementing the first index each time. If you aren't using any XSLX specific functionality then CSV is easier.Īs for your stuck part, isn't your indice backwards. OSheet.Cells = inputLines įirstly I'd ask the question if it is needs to be an XSLX file or just a simple CSV file instead. OSheet = (excel._Worksheet)oWB.ActiveSheet įor(int i = 1 i<=inputLines.Length i++) Ligar o excell e apanhar o objeto da app This is what i have so far, but since im stucked is not working. I can manage to do that with only one column in the txt file, but not with "dimensional" information.īasically i want to convert the information under this into a xls file.
Im trying to build a simple program to convert a txt file into xls using C#.
0 kommentar(er)
