I have created my RadGrid and have exporting to Excel working well when the user clicks on an export button in their browser.

I have also used the code below to make it so that the Excel file can be saved programatically without bringing up the file save dialog.  This code is also working well.

Now, what I need to do is automate and schedule this process:   the creation of the grid, the firing off the export to Excel function, and saving that exported Excel file to a directory on the web server.  In order to accomplish that, I created a windows application that would sit on the same web server and would call the web page that contains the grid.   That works fine.

The problem that I have is that I don't know how to fire the GridExporting event without using some client side interaction or client-side javascript.   I am using an HttpWebRequest in my windows application to make the web request, but HttpWebRequest doesn't support javascript, so it can't trigger the GridExporting event.

Is there anyway to call the GridExporting event from the server-side and not the client-side?   If so, during what event should I make that call from and what does that call look like?

I know that as an alternative, I could totally skip using RadGrid, and for these automated exporting calls, simply take my raw data and create an excel sheet programatically using NPOI or some other tool and save it.   The issue is that I will still be using RadGrid on the web, and I have built the web application so that the data in the grid can be customized significantly by my users (through sorting, grouping, hiding columns, etc), and I really want the programatically created Excel file to provide the same data, in as close to the same format, as if the user used the RadGrid's export to Excel function on the website.  

It seems that I am very close to making that happen, if I can just figure out how to trigger the export function on the server-side.

Thanks in advance for your help!


This is the code that I am using to save the Excel file programatically without bringing up the file save dialog.  This code is working great.

Hi,

How can I disable the title on the content area?
I have a title said: Rich text editor with ID...

I'm using the div mode.

As you can see in this demo, there is the title also:
http://demos.telerik.com/aspnet-ajax/editor/examples/contentareamodediv/defaultcs.aspx

Is there a way to get FormDecorator to style custom controls i have on my page? They are just modified DropDownList controls but the FormDecorator doesn't pick them up.

Hello,

I have a search function on every page. The way this works is that a button is pressed the Master page catches the button press and then redirects to a "suche.aspx" page.

On updating the Telerik dll this has stopped working in IE8. IE8 tries to download a file.

What I think causes the problem is at some point an extra "Response header" is added, "Content-encoding: gzip", so that there are now two, which confuses the browser (but not IE9 or Firefox -- FF renders the header as "Content-encoding: gzip, gzip" but accepts it).

The answer seems to be to use Response.ClearHeaders() before the redirect (or turning off postback compression, which worked when this problem was confined to a couple of pages and I could use the "excludeHandler" for those) .

I am hesitant, however, as a previous DLL required the removing of Response.ClearHeaders() for IE8 to work and I thought it best to get clarification as to the best practice here.

Thank you

Paul Herzberg

I output RadGrid to Excel <Excel Format="Html"></Excel>

Here are my issues; (I have attached a picture to help illustrate my questions)

 

1. Is there a way to know what row the Grid is currently writing to in Excel? Something like "Excel.CurrentRowNumber"?

Reason: I'm writing formulas to various cells during RadGrid1_ExcelExportCellFormatting but the first row of data it encounters gets written to Excel row 4 (because of the Grid Header). I tried using item.ItemIndex but that starts off at 0 (or 1 maybe, i don't recall). So my formulas are all messed up since I don't know what the current row in Excel is. I need to write out formulas like C4+D4 but I end up with C1+D1.
The problem gets worse as  GroupByExpressions are encountered. Each time my data is grouped another 2 rows get written to Excel and now my current row is off by even more.

2. Is there a way to interact with the output to Excel when GroupByExpressions are encountered? I'd like to adjust the cells during that time such as inserting formulas to sum up all the rows in a section for each column. Same question regarding the GridFooterItem..? I'd like to put "grand total formulas" in those various columns.

3. I can't get rid of column A. There is a blank column that gets written out (see my picture). It seems to be known as "column" so I tried hiding it such as:

RadGrid1.MasterTableView.GetColumn("column").Display = false;

but no luck. This is only a minor annoyance, I could live with this as the formula questions above are the more important showstoppers.

Thank you!!

I have a menu that has background images.  The menu is the appropriate width (lining up with other items within the div container) when zoom is set to 100% in IE, Chrome and Firefox.  However, when I zoom in the width varies in relation to the other items on the page.  Sometimes the overall width is narrower than it should be.  Other times it is wider than the container, which causes it to wrap.

Any insight into what the cause might be would be greatly appreciated!

Thank you,
--Larry--

I have a RadTabStrip + RadMultiPageView + RadPageView + RadWindow on mainpage.aspx

RadPageView  I am utilizing contenturl='contentpage.aspx'

I am wanting to do the following call on contentpage.aspx

var w = radopen('dialogpage.aspx', null);

w.maximize();

w.set_behaviors(Telerik.Web.UI.WindowBehaviors.Close);

But this only sets it to full screen within the bounds of RadPageView.

I cant do
var w = parent.radopen('dialogpage.aspx', null);

w.maximize();

w.set_behaviors(Telerik.Web.UI.WindowBehaviors.Close);

as I loose the ability to send requests back to the opening page utilizing:
UpdateFromPopup would be called on mainpage.aspx instead of contentpage.aspx
any ideas on how to get the radwindow to maximize??

Hello,

While working with the TreeList Drag and Drop example, I've noticed that there doesn't appear to be a way to drag child nodes to the top-most level. Given that it is possible to drag root nodes beneath their peers to create child nodes, and since this functionality can be seen in the TreeView Drag and Drop example, I would expect that the control also supports the aforementioned scenario.

So, is there a property or setting that I must set to enable this behavior on the TreeList, or if the implementation is more complex, may I request an example showing how to achieve this?

UPDATE: I've managed to implement this functionality using a custom "ItemDrop" event handler. I'm still interested in identifying a simpler solution though.

Why have none of the latest webinars been posted online?
Most of us are not able to attend the webinars live due to time differences.

Are those of us who do not live in the US now no longer allowed to watch them?

Hi ,

I am strange issue in particular page.
I am using client side binding using following tag
        <DataBinding Location="~/ReportManagement/ReportDesigner.aspx" SelectMethod="wmBindSecurity" />
After page load 10 records display properly, but in pagination bar page number is missing ,and also it is written 0 items in 0 pages.
and page size changing works perfectly.


On change of next or prev request is not going to server side.

Please help me .
I am using following code.

ASPX


JS

function RowSelected(rowObject, args) {

            if (args != null)
                gridEventArg = args;

            var length = $find(rgSecurity_id).get_selectedItems().length;
            var radGrid = $get(rgSecurity_id);
            var radToolBar = $telerik.findControl(radGrid, "rtbSecurity");
            var addButton = radToolBar.get_items().getItem(0);
            var removeButton = radToolBar.get_items().getItem(1);
            switch (parseInt(length)) {
                case 0:
                    addButton.set_enabled(true);
                    removeButton.set_enabled(false);
                    break;
                case 1:
                    addButton.set_enabled(false);
                    removeButton.set_enabled(true);
                    break;
                default:
                    addButton.set_enabled(false);
                    removeButton.set_enabled(true);
                    break;
            }
        }

Thanks & Regards ,
Somnath