Try to use epplus add worksheets to another workbook. If the work does not contain the pictures in the table can be copied, but if you include images hint parameter cannot be null, have seen similar?
CodePudding user response:
reference 1st floor Miaonly response: Imports Spire. Xls The Namespace CopyWorksheet_XLS Class Program Private Shared Sub Main (ByVal args As String ()) Dim workbook1 As Workbook=New Workbook () Workbook1. LoadFromFile (" sample1. XLSX ") Dim sheet1 As Worksheet=workbook1. Worksheets (0) Dim workbook2 As Workbook=New Workbook () Workbook2. LoadFromFile (" the sample2. XLSX ") Dim sheet2 As Worksheet=workbook2. Worksheets. AddCopy (sheet1) Sheet2. Name="copiedsheet "Workbook2. SaveToFile (" newsample2. XLSX ") End Sub The End of the Class End the Namespace In Spire. XLS. DLL to replicate, take pictures of the worksheet copy no problem, after the reference, the original, charge? After I have this to commercialization