View Complete Post
Hi! Can someone tell me how I can troubleshoot the
following error: "Encountered multiple versions of the same assembly
with GUID...try pre-importing one of these assemblies".
The website developed in VS 2010 (.Net 3.5). This error is only received on my
workstation. Another person developing the site does not experience
this issue at all. Also, not sure if this matters, but on my workstation the 'Assembly
Information...' dialog contains no values even though the 'AssemblyInfo.vb' file does specify values for the title, desc, etc.
The GUID being referenced in the error is the main project of the three projects
within the solution.
I tried looking through the GAC, but do not see any references to the projects or DLLs in the VS solution and am not sure what else/where to look.
If I delete the copy of the solution on my local machine and pull down a copy from source control (AnkhSVN) the solution will build with no error. Once I make any changes, such as adding a new aspx file, then the error is received.
I can provide any additional information needed.
I am trying to simply extract an excel data from an uploaded file an put it into a datatable. In this case the excel file has 3 rows but when I fill the datatable I only see row count of 2.
I tried changing HDR:NO; to HDR:YES and vice versa, but no luck.
What am I doing wrong? (Note: the excel file cannot have a headerrow)
string connstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + pFilePath + ";Extended Properties=\"Excel 12.0;IMEX=1;HDR:NO;\"";
OleDbConnection conn = new OleDbConnection(connstr);
DataTable dtTables = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
string strTablename = dtTables.Rows["TABLE_NAME"].ToString();
string strSQL = "SELECT * FROM [" + strTablename + "]";
OleDbCommand cmd = new OleDbCommand(strSQL, conn);
DataTable dt = new DataTable();
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
//At this point row count=2 which doesn't make sense
I'm trying to import (Custom Lists >> Import Spreadsheet) into WSS 3.0 and I'm getting the following message:
Refers to the _layouts
You are not authorized to view this page. You might not have permissions to view this direcotyr or page using the credentials you supplied. [More stuff here.]
Http ERror 403 - Forbidden
Is this just a permissions problem or is there some other underlying issue? Should you be able to upload an Excel spreadsheet (with links) into a Custom List?
I have several excel spreadsheet fils, each of them contains multiple work sheets that may storing images or data.
How could I merge all of these work sheets to just one .xls file and keep their original layout and style using asp.net?
Thanks in advance.
I have added the doc icons and MIME types to my SPS2003 farm and now it works properly with Office2007 documents, with the exception of 'protected' Excel files. In those cases where the Excel file contains a 'protected' worksheet, the user can
open the doc, unprotect the worksheet and make their edits. When they 'protect' the worksheet again and try to save the file, they get an alert that the destination file is 'read-only' and they must save it with a different name.
This only happens for 'protected' Excel 2007 docs residing on an SPS2003 site. Protected Excel 2003 documents work fine, as do unprotected documents. Any help y'all can be is greatly appreciated. I only have two users who are using
the protected worksheets, but they are the most vocal of my users.