Export not Working and one more question

Spreadsheet
#1

Thanks for all your help. I am 90% of the way home.

When I installed the plugin and had it working initially, I was able to create a PDF and export in Excel format. Now I can do neither. I also de-activated and deleted all the files, then re-installed and re-activated. Still can’t export.

Here’s my code:

[[spreadsheet]]

Also, once data has been exported, I want to open a new, empty spreadsheet. Haven’t been able to get that to work.

Thanks for your help.

#2

Hi,
what does occur when you press export button?
Could you provide link to your spreadsheet page?

To clear spreadsheet after exporting you may do the follow:

  1. add in file dhtmlxspreadsheet.js code which sends request to server:
			case 'export_pdf':
				this.export_to('pdf');
				// send clear request to server here
				break;
			case 'export_excel':
				// hide first column with row numbers before printing
				this.grid.setColumnHidden(0, true);
				this.export_to('excel');
				this.grid.setColumnHidden(0, false);
				// send clear request to server here
				break;
  1. Create at server side script using PHP API (docs.dhtmlx.com/doku.php?id=dhtm … :reference) which will clear required spreadsheet. Unfortunately there is no special method which clears all spreadsheet at once, but you may take all cells by sheet id and set empty value and style for every one of them.
#3

Here’s the link.

cos.nyghtfalcon.com/?page_id=103

When I click on the PDF button, a new tab opens but nothing is displayed. When I click on the Excel button, nothing happens.

Once again, this did work.

#4

Hi,
problem is confirmed.
you should update file dhtmlxsh_export.js from attachment to fix it.
dhtmlxsh_export.zip (1.4 KB)

#5

Thank you

#6

THANKS VERY MUCH!! :slight_smile:

#7

Check below link
123triadprojects.com/cms/omkar/cms/filebase

it just exports the the excel sheeti without any data in it already tried upgrading with the provided js.

Thnks in advnc