Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Excel export

Answered
Jimmy Urrutia asked on April 24, 2020

The company I work for recently acquired the flexmonster license … everything is going great … the problem is that in the excel I export, I need to put a heading to that excel, and this one with a defined font and letter. .. I also need that the cells of the excel that I export adapt to the size of the text, which I have been trying for a long time and I have not been able to achieve … well … I need to know if this can be done with some setting? and if you can tell me where in the documentation is

2 answers

Public
Jimmy Urrutia April 24, 2020

Well I found the problem because the cells did not fit the text and it was because it called pivot.expandAllData (); after ExportTo_excel (); .. well today’s point is that in

var params = {
    filename: ‘flexmonster’,
    header: “\ n \
             \ n \
             \ n. PRODUCTION COEFFICIENT REGISTRY \
             \ n \
             \ n (1) NAME CAMPANY C.A. LTDA. DE C.V. (4) Code: 000-00000000000000-0 \
             \ n (2) N.I.T .: 0000-000000-0000-0 \
             \ n (3) Economic activity: Trading company Industrial process Both \
             \ n. Other Agricultural Services “,
    footer: “Table Footer” //,
    // excelSheetName: ‘Report’,
    // showFilters: true
    // useOlapFormattingInExcel: false
  };
  pivot.exportTo (‘excel’, params);

where I define the cells for header I would like to put different sizes … will that be possible ???? from flex

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster April 24, 2020

Hello, Jimmy,
 
Thank you for reaching out to us.
 
We are happy to hear that you did manage to resolve the problem with expansion.
 
Concerning the header customization, our team would like to kindly inform you that such a feature is not supported in the current version of Flexmonster.
All headers are exported as simple text with predefined size 10.
 
Please contact us in case other questions occur.
 
Best regards,
Illia

Please login or Register to Submit Answer