[KampParticipant]

Hi Peter,
yes I tried that some time ago, but when exporting as xls I was unable to also export colored rows/columns.
This is a mandatory customer requirement, so I’m sticking with the old method for now.

with friendly regards,
kamp

[KampParticipant]

Hi Ivan Peevski,
I see. For now, could you make it so there won’t be an error message when opening a .xlsx file that has been exported with cellclassname styling?
I’m very much looking forward to you implementing cell styles to xlsx export though, as the new method is way more convenient.

with friendly regards,
Kamp

[KampParticipant]

Hi Ivan Peevski,
I’ve got it working thanks to you, but I still have an issue:

I’m setting styles (fore-/background color) via cellclassname.
This works fine when exporting via exportdata (the resulting xls file will be colored correctly).
When exporting via exportview the xlsx file seems damaged.
Opening that file Excel starts the Repair dialogue, which subsequently removes the styling.

Repaired Records: Cell information from /xl/worksheets/sheet1.xml part

with friendly regards,
Kamp

[KampParticipant]

Hi jQWidgets team,
sounds great, but unfortunately it doesn’t work for me.

In jqxgrid.export.js -> _exportData(…) ->
var dataExporter = new $.jqx.dataAdapter.DataExporter( { exportHeader: dataExport.header } );
fails with: TypeError: $.jqx.dataAdapter.DataExporter is not a constructor

I’m using jQWidgets v13.1.0
Not too sure if this is a problem on my end

wfr,
Kamp

[KampParticipant]

Hi jQWidgets Team,
any news on this one?
customer is getting bummed out by the message.

with friendly regards

[KampParticipant]

Hello JqWidgets team,

any news on this feature?
When exporting a couple thousand lines with differently colored rows, it can take quite a while (even when dataexport.php is hosted on the same network).
Without digging into the implementation of export I’ve looked at counting requests, however this is not very reliable to get an export done event.

with friendly reagards,
Kamp

[KampParticipant]

Hello Peter,
I updated to 10.1.6 and that seems to have done the trick.
Thank you very much!

wfr

[KampParticipant]

Hello Martin, thanks for the reply.
Unfortunately I do not have a publicly available database to query from.
Do you happen to provide one with at read access only?

Some additional information on how I set it up:
I’m using Nuxt (which I know is not officially supported), however I’m forcing it to run on client side only which should make it run as if it was plain Vue.

I basically set it up as follows:

<template>
  <client-only>
    <span v-if="columns.length == 0" >Loading</span>
    <JqxGrid
     v-else
     :source="source"
     :columns="columns"
    />
  </client-only>
</template>
<script>
let JqxGrid = null;
if (process.client) {
  JqxGrid = require("jqwidgets-scripts/jqwidgets-vue/vue_jqxgrid.vue").default;
}
export default {
  components: {
    JqxGrid
  },
  data() {
    return {
      source: {...}
      columns: []
  }
}
</script>

and in nuxt.config.js

export default {
  css: [{ src: '@/assets/scss/main.scss', lang: 'scss' }],
  build: {
    transpile: ['jqwidgets-scripts']
  }
}

and main.scss

@import "jqwidgets-scripts/jqwidgets/styles/jqx.base.css";
@import "jqwidgets-scripts/jqwidgets/styles/jqx.bootstrap.css";

That’s about it.
I do not use jqx.dataAdapter(source) to feed the source into JqxGrid as it’s used within vue_jqxgrid.vue anyway (could this be an issue?).
columns gets filled within beforeMount() via an axios call, since I’m using the my grid component for a couple of different queries.

wfr

[Author]

Posts