absolutenax.blogg.se

ObjShareStringTable = New SharedStringTable() ObjShareStringTablePart = objWorkbookPart.AddNewPart _ If objShareStringTablePart Is Nothing Then ObjShareStringTablePart = objWorkbookPart.SharedStringTablePart ObjSeetData = objWorksheet.Descendants(Of SheetData)() _ ObjWorksheet = objWorkSheetPart.Worksheet ObjWorkbookPart = objSpreadsheetDocument.WorkbookPart Using objSpreadsheetDocument = SpreadsheetDocument.Open _ ObjOpenFileDialog.Filter = "Excel Document (*.xlsx)|*.xlsx" Private Sub Button1_Click( ByVal sender As System.Object, _īyVal e As System.EventArgs) Handles Button1.Clickĭim objOpenFileDialog As OpenFileDialog = New OpenFileDialog()ĭim strFilePath As String Dim objWorkbookPart As WorkbookPartĭim objShareStringTablePart As SharedStringTablePartĭim objShareStringTable As SharedStringTable I can open the file using something like: ObjectB strings might be written as follows: So ObjectA strings might be written as follows: I need all the strings in each object to be writen to the same row, but each string will be in a seperate column. String1, String2, String3, String4, String5 (always 5 strings) I have a collection of objects (number of objects will vary).Įach object contains a series of strings. Everyone seems to have their own method and each one is more difficult (i.e. I have done a lot of searching and cannot seem to find any clear-cut answers on how to do it. xlsx file and create a new sheet (works great).īut I now need to open it and write some data to it. I have found sources that have allowed me to piece together code to create a new

net too! I need some help with writing some strings to an excel spreadsheet.

I am not very good with the Opem XML API at all! In fact, I am still learning.