Hot answers tagged

3

SharePoint won't be able to create a list from a spreadsheet in that format. Nor will you be able to copy and paste it into quick edit mode. (Theoretically you would be able to copy and paste it, but it would not work as intended.) Luckily there is an option to rotate data in Excel so you should be able to correct the format and then import it into ...


2

APPROACH 1 First add reference of two COM components. Microsoft Office Object Library Microsoft Excel Object Library excel = new ApplicationClass(); excel.Visible = false; string workbookPath = url; Workbook excelWorkbook = excel.Workbooks.Open(workbookPath, 0, false, 5, "", "", false, XlPlatform.xlWindows, "", true, false, 0, true, false, false); Sheets ...



Only top voted, non community-wiki answers of a minimum length are eligible