npoi
npoi copied to clipboard
Support for Setting Cell Values by Position in ISheet
File Type
- [ ] XLSX
- [ ] XLS
Use Case
int x = 0;
int y = 0;
object value = "Hello npoi!";
ISheet sheet = workbook.CreateSheet("sheet");
sheet.SetPointValue(x, y, value);
Description
In the process of using NPOI for Excel file operations, the current approach of manually creating rows and columns and then setting cell values becomes cumbersome and time-consuming, especially when dealing with large datasets. I would like to propose the addition of a more convenient feature to NPOI that allows users to set cell values based on cell positions, thus improving efficiency.
This looks to be a nice-to-have feature. If you are willing to create a PR, I will review the code.