npoi icon indicating copy to clipboard operation
npoi copied to clipboard

Support for Setting Cell Values by Position in ISheet

Open Silence-Qiu opened this issue 1 year ago • 1 comments

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.

Silence-Qiu avatar Sep 20 '23 11:09 Silence-Qiu

This looks to be a nice-to-have feature. If you are willing to create a PR, I will review the code.

tonyqus avatar Jan 09 '24 00:01 tonyqus