Hello,
I use C# ASP.NET for my page, and I need to work with existing Excel files.
Does the Aspose.Cells .NET version provide a feature that allows you to import an Excel file, such as qwer.xlsx, and map it to a form? Specifically, I am looking for a way to upload the Excel file, map it to a unique form, and later update the form’s content by retrieving data from a database.
Or do any other versions of Aspose.Cells offer similar function?
Thank you.
@Shawnse
Sorry, Aspose.Cells currently does not support mapping Excel data to forms. Aspose.Cells follows the rules and specifications of MS Excel. It is not possible to directly map data to a form in Excel. If you can manually implement this requirement in Excel, please provide us with a sample file and we will check it soon.
We support creating and manipulating tables based on Excel data. Regarding how to handle tables, please refer to the following document.
sample18.png (14.8 KB)
For example,
here is my Sample, and I use this format as a form. If I upload file and click save button, this becomes one of frame (saving as methods or saving code into DB or something…).
And later, I want to call this frame and change only title, content, price, total.
Does it not supported?
@Shawnse
By examining the image you provided, we can see that the form you mentioned is actually a table. You can refer to the documents related to tables, and of course, you can also modify the data in cells. Please refer to the following document.
Ok. Thank you.
Just related question,
because my whole tables’s structures are complex,
If I import a file like that, is there a feature that automatically generates code recognizing merged cells and the table structure?
@Shawnse
Thank you for your feedback. You are welcome. At present, it is not possible to automatically generate these complex tables. You need to use Aspose.Cells APIs to implement your needs. If you encounter any problems or questions while using Aspose.Cells, please feel free to contact us at any time.