Export xlsx

Hello good afternoon.

I can not export the contents of the drillDown, keeping the numeric format of the column ([EnergiaFacturada]) and the formats of the columns ([startdate] and [changedate]). I send you an example if you can help me identify where I can have the error.

Thank you very much for your collaboration.

5 answers

Public
Dmytro Zvazhii Flexmonster February 12, 2018

Hello Jose,
Thank you for your question. Could you please send us more information about your case? It can be either sample project or video example. Such information will help us a lot in our further investigation.
Waiting for the update from you.
Regards,
Dmytro.

Public
Jose Antonio Veintimilla February 12, 2018

I think that you attach an example file. Anyway, I’ll send it back to you. It is a file js (example.js)

Public
Dmytro Zvazhii Flexmonster February 13, 2018

Hello Jose,
Thank you for providing us with the code example. We have found a couple of things that need to be changed: 
1. We have noticed that your date fields (“fechaInicio” and “fechaCambio”) are not in ISO 8601 format. For now, our supports only dates in ISO 8601 format – https://www.flexmonster.com/doc/data-types-in-json/. The other date formats are possible but may lead to unpredictable behavior. In your case, the component defines it as a string, therefore, the datePattern cannot be applied. We recommend you to replace it the following way: “04/12/2017” -> “2017-12-04”.
2. Also, we noticed that you are expecting your dates to look like date string. Therefore, please define the metaobject with the dataTypes for your JSON data object as described here – https://www.flexmonster.com/doc/data-types-in-json/.
Example: 

var nominal=[
//metaobject
{
...
"fechaInicio": {
  type: "date string"
 },
 ...
},
//data
{
   ...
"fechaInicio": "2017-12-04",
   ...
},
...
]

3. Please move the options object with the datePattern property into the report object. It will look something like this:

...
"report": {
 ...
 options: {
  datePattern: "dd-MM-yyyy"
 },
 ...
}

Please let us know if everything works fine for you.
Regards,
Dmytro.

Public
Jose Antonio Veintimilla February 13, 2018

Hi.

We are getting better. I can now mount the date format in the pivot correctly in the fields Start date and Change date. I have verified the difference of passing the type date or date string (1 value date or 3 values (year, month and day)). I have also worked with the Options object: dataPattern in two formats DD / MM / yyyy and yyyy-MM-DD and it works in the pivot and in the drilldown perfectly.

Now I have the problem when I export the drilldown to excel. I do not pass any value to the columns dates. The cells are created empty. Nor does it respect the numerical formats. Treat them as text value. I insist only when I export the nominal result (drilldown). When I export the pivot works well.

Which may be due?

Public
Tanya Gryshko Flexmonster February 14, 2018

Hello, Jose,
I’m glad to hear that the date format is displayed in the pivot correctly for your case. Please find your questions answered in another thread
Regards,
Tanya

This question is now closed