Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

EXCEL export can export WYSIWYG #7950

Open
afr751116 opened this issue May 13, 2024 · 0 comments
Open

EXCEL export can export WYSIWYG #7950

afr751116 opened this issue May 13, 2024 · 0 comments

Comments

@afr751116
Copy link

I'm submitting a ... (check one with "x")

[] bug report => see 'Providing a Reproducible Scenario'
[] feature request => do not use Github for feature requests, see 'Customers of AG Grid'
[x] support request => see 'Requesting Community Support'
    this.gridApi.exportDataAsExcel(this.getParams());
  getParams: () => ExcelExportParams = () => {    
    return {
      columnKeys: this.columnKeys,
      prependContent: this.getRowsPrependContent(), 
      author: '', 
      sheetName: this.tabTitle,
      fileName: this.tabTitle, 
  
       processCellCallback: params => {
       }}}

Try EXCEL export, how can the same effect as Csv export, export table display, without the need for separate processing
Problems caused by not handling manually:

  1. If leading zeros exist, zeros are deleted from EXCEL
    2, similar to the following custom code does not take effect, exported the original code, rather than display the value
    valueFormatter: params => { return !params.node?.isRowPinned() && params.value ? this.lookupValue(this.departmentMappings, params.value) : null; }

Please tell us about your environment: WIN2019 Visual Studio Code

  • AG Grid version: 30.2.0
  • Browser: Google Chrome 123.0
  • Language: [ TypeScript 4.3.5 | ES5]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants