Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to send data in excel format through Mail.
Anyone help me with the configuration.
Regards,
Keerthi KS
you have to use macros for that have a look at this
Hie...
This is what I have :
1. Install a PDF-printer
I installed "Bullzip PDF Printer" on the machine where the report runs.
=> Google is your friend
2. Make your QVW and a report, write down the reportname (RPxx)
3. In QV, enter the following script :
This script has a connection to 2 other script, just copy/paste them and change some parameters
Make sure that security is set to SYSTEM, both settings.
Hope it works for you !!!
Hi Gautham,
I am doing it for the first time. I never worked on server .
Can you please provide me in detail. What has to be done if i need to send data in excel format.
Thanks,
Keerthi KS
Hi,
Check this link it has sample code, you can implement the same in your dashboard.
Regards,
Jagan.
Hi Jagan,
Where do i run these scripts ?
Regards,
Keerthi KS
Hi,
You need to create a macro using in Edit Module or Ctrl + K and trigger it on button click or wherever you required.
Regards,
jagan.
It wud be Ctrl+M to edit the module..
HI,
Export to Excel
FUNCTION ExcelExport(objID) set obj = ActiveDocument.GetSheetObject( objID ) w = obj.GetColumnCount if obj.GetRowCount>1001 then h=1000 else h=obj.GetRowCount end if Set objExcel = CreateObject("Excel.Application") objExcel.Workbooks.Add objExcel.Worksheets(1).select() objExcel.Visible = True set CellMatrix = obj.GetCells2(0,0,w,h) column = 1 for cc=0 to w-1 objExcel.Cells(1,column).Value = CellMatrix(0)(cc).Text objExcel.Cells(1,column).EntireRow.Font.Bold = True column = column +1 next c = 1 r =2 for RowIter=1 to h-1 for ColIter=0 to w-1 objExcel.Cells(r,c).Value = CellMatrix(RowIter)(ColIter).Text c = c +1 next r = r+1 c = 1 next END FUNCTION SUB CallExample ExcelExport( "CH01" ) END SUB
What are the changes should i do here. I am getting error "expected end"
If you have any sample qvw please attach it. it would be very helpful
Regards,
Keerthi KS