search

securedeveloper / react-data-export

Export dataset in react.
https://securedeveloper.github.io/react-data-export/
MIT License
179 stars 191 forks source link

Can not see fill and font colors in .xlsx file with Microsoft excel when exporting #144

Closed mohitkyadav closed 3 years ago

mohitkyadav commented 3 years ago

My reason:

Can not see fill and font colors in .xlsx file with Microsoft excel when exporting using react-data-export https://stackoverflow.com/questions/64673968/can-not-see-fill-and-font-colors-in-xlsx-file-with-mirosoft-excel-when-exportin

Steps to reproduce:

  1. Export some styled data to excel file, make sure you use some kind of font color or fill color in styles.
  2. Open the same file in google sheets and microsoft excel
  3. Notice the color styles are only visible in google sheets and MS excel replaces black with any color styling MS excel image Google Sheets image

Lib Version:

0.6.0

YVeselovskyi commented 3 years ago

I have same issue

mohitkyadav commented 3 years ago

This is fixed, check my answer @YVeselovskyi https://stackoverflow.com/questions/64673968/can-not-see-fill-and-font-colors-in-xlsx-file-with-mirosoft-excel-when-exportin/64678030#64678030