本帖最后由 Lynn.Dou 于 2024-2-6 14:09 编辑
产品:GcExcel .net
版本:V6.2.5
复制合并单元格样式复制不正确
最后输出结果:
使用代码:
- const string path = @"D:\Download\603717_03a0e44f-d637-4ea9-9ad2-d82558e8827d_new.json";
- // output pid
- Process currentProcess = Process.GetCurrentProcess();
- Console.WriteLine($"pid: {currentProcess.Id}");
- Workbook sourceWorkbook = new Workbook();
- // workbook.Open(path, OpenFileFormat.Sjs);
- sourceWorkbook.FromJson(File.ReadAllText(path));
- IRange source = sourceWorkbook.Worksheets[0].Range["C2:N2"];
- Workbook targetWorkbook = new Workbook();
- targetWorkbook.FromJson(sourceWorkbook.ToJson());
- targetWorkbook.Worksheets[0].GetUsedRange().Clear();
- IRange target = sourceWorkbook.Worksheets[0].Range[source.Row, source.Column, source.RowCount, source.ColumnCount];
- // copy style
- source.Copy(target, new PasteOption
- {
- PasteType = PasteType.Formats | PasteType.ColumnWidths | PasteType.RowHeights
- });
- target.Value = source.Value;
- // save to target.sjs
- targetWorkbook.Save(@"D:\Download\target.sjs", SaveFileFormat.Sjs);
- string json = targetWorkbook.ToJson();
- // save to target.json
- File.WriteAllText(@"D:\Download\target.json", json);
复制代码
|
|