MiniExcel icon indicating copy to clipboard operation
MiniExcel copied to clipboard

Support batch update cell value

Open shps951023 opened this issue 3 years ago • 1 comments

image

shps951023 avatar May 28 '22 14:05 shps951023

Draft :

void Main()
{
	var updateCells = new Dictionary<string, object>()
	{
		{"A1","A1_Update"},{"B15","B15_Upadte"},{"H12","H12_Update"}
	};
	var Path = "xxx.xlsx";
	MiniExcel.Upate(filePath:Path,sheetName:"Sheet2",updateCells);
}

Problems:

  • Need to load all excel data then update every time

shps951023 avatar May 28 '22 14:05 shps951023