feat(facade): add set font apis and get cell model data api

[hexf00]

• I am sure that the code is update-to-date with the dev branch.

close #1009

Add Facade range APIs:

• getCellData

const activeSheet = univerAPI.getActiveWorkbook().getActiveSheet();


const range = activeSheet.getRange(0, 0);
range.setValue('a');

// 获取单元格数据
const cellData = range .getCellData(); // like { v : "a" }

• getCellStyleData

const activeSheet = univerAPI.getActiveWorkbook().getActiveSheet();

// 获取单元格样式数据
const range = activeSheet.getRange(0, 0);
range.setFontWeight('bold');

const cellStyleData = activeSheet.getRange(0, 0).getCellStyleData(); // reuslt like { bl: 1 }

• setFontStyle
• setFontLine
• setFontFamily
• setFontSize
• setFontColor

const activeSheet = univerAPI.getActiveWorkbook().getActiveSheet();

// 设置单元格样式数据
const range = activeSheet.getRange(0, 0, 2, 2);
range
  .setFontWeight('bold')
  .setFontLine('underline')
  .setFontFamily('Arial')
  .setFontSize(24)
  .setFontColor('red');

//移除单元格样式数据
range
  .setFontWeight(null)
  .setFontLine(null)
  .setFontFamily(null)
  .setFontSize(null)
  .setFontColor(null);

[codecov]

Codecov Report

Attention: 7 lines in your changes are missing coverage. Please review.

Comparison is base (15c7ca0) 29.63% compared to head (14c722e) 29.72%.

Files	Patch %	Lines
packages/facade/src/apis/sheet/f-range.ts	90.27%	7 Missing ⚠️

Additional details and impacted files

@@            Coverage Diff             @@
##              dev    #1266      +/-   ##
==========================================
+ Coverage   29.63%   29.72%   +0.08%     
==========================================
  Files         843      843              
  Lines       47792    47859      +67     
  Branches     9795     9811      +16     
==========================================
+ Hits        14162    14224      +62     
- Misses      33630    33635       +5     

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

[github-actions]

View Deployment

📑 Examples	📚 Storybook
🔗 Preview link	🔗 Preview link

[wzhudev]

Good work! Though minor changes would be appreciated.

[wzhudev]

把 SetStyleCommand 改成同步的命令吧，然后这里变成 syncExecuteCommand

[hexf00]

这里参照 Apps Scripts 设计，是链式调用，没有返回调用的状态。 保持异步调用会不会更快？

[wzhudev]

不会，SetStyleCommand 内部实现就是同步的

[hexf00]

了解了，后续调整下