.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

VB.net issue when using dsoFramer to display Excel Worksheet

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :Windows Application
Hi to all, I'm using the dsoFramer control to display an Excel file , the problem is that suddenly it stops working fine and I'm receiving the following message. "Unable to display the inactive document.  Click here to reactivate the object" So I have to click on the Excel Sheet to start showing the information... that's awful for me and my tool users? anybody knows how can it be fixed. FYI, I use Visual Basic.net 2008 Express Edition

View Complete Post

More Related Resource Links

Sharepoint 2010 w/ Webapps, Excel Services Webpart display issue.


I have Sharepoint 2010 installed with WebApps 2010, and can use it to edit documents in IE without any problems at all.  Word and Excel work just fine.

But on MOSS 2007, I could have it display the Excel page as a webpart, that you can click on, and open it anyways.   But no matter what I try in 2010, all I get is the Webpart heading has a link to the file that works, but the contents always reads:

To display a workbook in this Web Part, you must first select the workbook.

To select a workbook, open the tool pane, and then edit the Workbook property.
Click here to open the tool pane.


How can I fix the preview in the webpart?




display data into GridView from excel sheet

I have to display data from excel sheet into my gridview and also I need to figure out a way to store data into excel files from my web page. I am using C# 3.5, VS 2008.

display data in excel 2007


 I am using .net  version 1.1  and  excel 2003 to display data.I need to display data in 2007 .Can  anyone suggest the reference to be added ,connection string change and what should be imported.  

export to excel issue


Hello ,

I have a browser enabled form which i published to sharepoint ..now i want to export the contents of the form to excel..i have 1 repeating table and two repeating sections ..whenever i go to export to excel and then choose just one repeating table or a repeating section or any option other than export all form data i get an error ...first the progress bar just freezes and then when i end the task through task m anager i get a msg that microsoft excel could not start.make sure excel is installed correctly and then try again....

Can somebody tell me how to debug this..i have tried the export of a form containg repeating table and sections and it works good ..so that means there is some problem with my form..so now can somebody give me an idea as to what can the problem be and how can i debug it.


ASP.NET Excel Export Issue



I am trying to export data from SP to a .xlsx sheet. Total no of rows is more  than 15000 with total of 13 columns.The data is generated with the help of SQL Server SP. Till this point it is working fine. However while exporting to excel I do not get any data , the excel  has blank content.

If I have records less than 12000 it generated the excel report with  relevant data. However as row increases the report is blank.

Also the excel is generated through the code but when I deploy to server and try to generate it generates a blank excel. 

 Please advice what needs to be done. I have tried multiple options but none works.

An issue of using UDF in Excel Service

I am using Excel Service and it call an UDF(User Defined Function) to get data from a list. Currently I come accross following issues. Any one can give me suggestions are very appriciated. 1. In the UDF, if I marked the method as "ReturnsPersonalInformation=true". The data cannot be shown correctly, all cells appear "#Value?". 2. When I fist time upload a excel file to the Document Library, then open the excel on browser. All cells appear "<nativehr>0x80070005</nativehr><nativestack></nativestack>". When I manually click "Calculate Workbook", then the data comes correctly. Thanks again for any hints.

Issue while exporting to Excel

Hi All, We are having report in SSRS 2005, everything is working fine while Running the report on BIDS as well as on Report Server, but as soon as we export the report to Excel it is creating issue(S) not just a issue. First - I'm not able to see "Footer" in Excel, although it does exist in BIDS as well as Report Server. It is visible while doing Print-Preview in Excel, why so is it a bug, is their any work around to make it visible without doing Print-Preview, please do let me know! Second - It is regarding "Header", I have couple of text boxes in my Report Header, as soon as I include text boxes in Report Header and when I export to excel, the rows & columns height as well as width is getting disturb (meaning some getting compressed and some getting expanded), so to make it look attractive we have to manually arrange in proper order before delivering to our end-user, Can anybody tell me why rows & columns are getting disturbed and also how to arrange with exact height & width without any manual interpection, please help me out, this is getting me crazy?   Thanks Regards, Kumar

ASP.Net Export Excel issue

Is there file size limit while exporting excel 2007 file using Microsoft.ACE.OleDB driver from ASP.Net? I can export file with any size (like 10 MB) when same code is used with Console app, but with ASP.Net page I am only able to generate file of around 500 Kb. When data exceeds this, it can not insert into the file. Can someone help?

Issue with Excel automation in C#

Hi, I am dynamically creating an excel file with some list options using C#. There will be 3 or more columns with drop down list. The issue is that in some columns there will not be values in some rows. But the drop down list shows all the empty column values also. Is there a way by which I can filter the excel column with all non empty values? Sample Code  Range r = (Range)ExcelWS.Columns.get_Item(c.Ordinal + 1, Missing.Value);r.Validation.Add(XlDVType.xlValidateList, XlDVAlertStyle.xlValidAlertStop, Missing.Value, "=$B:$B", Missing.Value);r.Validation.ErrorMessage = "Please select from available options";r.Validation.IgnoreBlank = true;r.Validation.ShowError = true;r.Validation.InCellDropdown = true;  

SSIS issue with dynamic excel sheet name

Hi Team, I am creating a Excel file dynamically using a script, excute sql and then the dataflow. I am not able to cretae a excel sheet name without an underscore exisitng file: "team data" even though am giving the table name in excute sql task(which is excel sheet name) as "team data" it is creating the name as "team_data" because of which the package is failing? I am able to achieve this with an underscore, as it is a client requirement to generate wihtout an underscore am posting this question. Is this an issue with Sql server 2005? Thanks, Eshwar  

Issue with valiadation of excel connections

Hi Team, I have an issue with a package I have a package which takes input and output file names dynamically from variables.  I made the delay valiadation of excel connection as true. after 1st execution when i close and reopen it again it is showing errors and execution is failing from second time. Thanks, Eshwar.

How do I display excel, pdf and word binary data in a gridview?


Hello forum

I'm using the following code to upload images, pdf files, word files and excel to a sql table as binary data.  However, I can only figure out how to display the images but am clueless about the other type of files.  What adjustments do I need to make so that with a button click I can access the other files?  't By the way, I'm using an image control to display the binary data and I'm aware that that will only work to display images, I just don't how to access all the other types of files once uploaded. Thanks

Imports Microsoft.VisualBasic
Imports System
Imports System.Data
Imports System.Configuration
Imports System.Web
Imports System.Web.Security
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Web.UI.WebControls.WebParts
Imports System.Web.UI.HtmlControls
Imports System.Data.SqlClient
Imports System.IO

Partial Class Uploads_UReceipts
    Inherits System.Web.UI.Page
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

        If Request.QueryString("ImageID") IsNot Nothing Then

            Dim strQuery As String = "select Name, ContentType, Data from tblFiles where id=@id"

            Dim cmd As SqlCommand = New SqlCommand(strQuery)

            cmd.Parameters.Add("@id", SqlDbType.Int).Va

SSRS 2005 Render Format Excel Issue with Time Field


I have a report that uses a datetime field but gets populated only with the time. So, in SQL db, it gets stored with a default date value of 1899-12-30 12:01:01 with the correct time filled in. Report in SSRS Preview mode displays the value just fine when I use the Time format in Layout mode. I build and deploy and able to view the report in a web browser with no problem displaying the time field. But when I subscribe to the report and choose Excel render format, when I open up the Excel file from the email that was sent, I get negative decimal values. I have tried every possible Time format in SSRS but I get the same result. I also tried just the default and still gives me negative decimal values that show up as ####### in Excel.

Any help will be greatly appreciated. Thanks

SSRS 2008 formatting issue - different in visual studio preview/pdf/excel vs. internet explorer


The formatting of the report is perfect when viewed in Visual studio and also after exporting it to pdf or excel. But when I deployed my solution and opened it on IE/Firefox there is a lot of problem in formatting. Specifically the row height is giving me a problem. I manually entered them to be 0.1in and made the CanGrow field as false to force that row height but some rows in the tablix expand ( to 0.15in, which is the height of my header). This is true for a matrix as well. Is there is a feature to lock the row height in IE o any other web browser?


Sharepoint Workspace, name display issue



I was wondering if anyone else had seen this.  On my Sharepoint site, it properly shows my name associated with the content that I create in the form of Wildes, John.  When I connect my SharePoint Workspace software to the sharepoint sites I wish to work with, all the names have two (2) commas in them, as in  Wildes,, John

Why is this...? 



John Wildes | Senior Enterprise Architect | United Airlines | Desktop Engineering

Visio & Excel serivices error during display document


Hi, all!

I have allready installed and configured SP 2010 Enterprise. Configured Excel and Visio Services (created services, configured Application ID for external data). Then activated enterprise features on my site collection and add excel and visio documents to document library.

When I try to view them in browser I get error: server can't process request .

This problem disapeared in my developer server after I have installed MS Office Excel and Visio on my server. Should I do that for my product server or there are other way to solve this problem?

Excel Connection Manager: Use OpenRowset with Space(s) in Worksheet Name


Is there a way to use Excel Connection Manager with OpenRowSet when the worksheet has a space in the name (e.g. "My Sheet").  I am using SQL Server 2008R2.

OpenRowset works fine without spaces in the worksheet name, but generates an error when a space is present.  I have tried multiple [] and ' ' combinations to bracket the worksheet name. 

JG4 documented the same problem in a posting titled "Skipping leading rows in Excel" (at the bottom of the thread):



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend