I am actually bit confused to say. I googled for applying styles in my spreadsheet i got some functions in which they mention about the font, borders etc which i need but i dont know where should i use or how should i implement. When i tried to implement like cell.StyleIndex=8 // Which is modified as per my need but there is no effect in the cells
View 1 Replies
How to read data from OpenDocument Spreadsheet and show the data in gridview....
View 1 RepliesPossible Duplicate: Create Excel (.XLS and .XLSX) file from C#
I have some code that generates a zip file that contains multiple CSV files and streams it back to the user (no file is saved on the server). However, I want to create an excel workbook instead (can be traditional xls or Office Open XML xlsx format) with each CSV 'file' being a spreadsheet.
How can I do this, without resorting to Office Automation on the server or a commercial 3rd party component?
I have a form that allows a user to import a spreadsheet. This spreadsheet is generally static when it comes to column headers, but now the users want to be able to include an optional column (called Notes). My code crashes when I try to read the column from the spreadsheet if it doesn't exist.
[code]...
I'm working on a project which requires me to plot a graph using Visual Studio ASP.Net from a data I've collected either in .txt or .xml format. The data consist of, eg. 15 records, but I'm only needed to plot 8 graphs out of the 15 records.
View 1 RepliesI'm exporting an ASP.NET gridview to Excel using the following function. The formatting is working really well, except I need to freeze the header row in Excel on the export. I'm really trying to avoid using a 3rd party Excel plugin for this, but unless there's some archaic excel markup in my AddExcelStyling function.
[code]....
I have a 2 dimensional array, I want to convert it to an Excel document using C#.
View 2 RepliesI have a datasource of an excel spreadsheet provided by a customer. The data is biographic information about clients. The last row contains a web link to view an image of the subject. I have open access to download the spreadsheet and can click each image to view the full jpg in IE.
What would be the best method to loop through the image link to deposit the image into a central file location? The datasource contains 50K subjects and is updated monthly, this is why a manual process is out of the question.
I'm trying to upload an excel spreadsheet using the FileUpload control, read the excel sheet using OleDb connection, and save the strings onto a sql server database.Then, I'm trying to read each string in another method.My web app is currently hosted on the network on my local box, and using savePath= @"C:desktop" like I had it previously wasn't working, so I figured using a sql server database would work for being able to save the file and open it again... but I'm getting confused on how to do so, so i tried using my old savePath but it's not working anymore. So... I'm really at a lost on what to do and how to fix it.
[Code]....
How to do something like this without actually downloading the spreadsheet to the local machine? Any tools or what not out in the world for doing something like this? Does sharepoint allow for .xlsx editing in a page?
Anything short of writing all the inputs and mapping them with backend code?
On an .aspx page in a web site I need to retrieve some data from a sql server database and, instead of displaying it in a Gridview, I need to put the data in a spreadsheet and present the user with a Save As dialog.
I'd prefer to do it without using the Office / Excel / Interop com object - so, from what I've read so far, I can do this by returning XML data from SQL Server?
Normally I get data from SQL Server and populate a dataset or datareader with it - and then use this as the Datasource of a GridView.
If I run this in SQL Server ...
Code:
SELECT UserID, UserName FROM tblUsers FOR XML Auto, Root('Users')
It produces this ...
Code:
<Users>
<tblUsers UserID="1" UserName="Steve" />
<tblUsers UserID="2" UserName="Andrea" />
<tblUsers UserID="3" UserName="Zebedee" />
</Users>
So, first question - how do I get the data from SQL Server into my .aspx page? (All data access is done with stored procedures - so, from my data access class normally I create, for example, a SQLDataReader and populate it by calling a stored procedure. What object would I populate with the results of a stored procedure that contains a select statement with 'FOR XML Auto'
Then, assuming I get the XML into the .aspx page - how do I get it into a spreadsheet so that there are two columns called UserID and UserName and 3 rows with 1, 2 and 3 in the first cell and Steve, Andrea and Zebedee in teh second cell?
Why StyleSheet.css is not displaying the picture depends on the situation. It displays “Taken!“ or "Available!" but no picture. I am using Ajax with asp.net
[code].....
I am new to MVC so I would like to know how would you switch the stylesheet of the view on postback?
I know how to do this in webforms but in MVC it does not appear to be done the same way.
if i have a single CSS stylesheet for a website and only want to declare it once, that is, not use the following code on every aspx page..
<link href="stylesheets/general.css" rel="stylesheet" type="text/css" />
Am i forced to use a .master page? or is there another way to do this..
My application sets the css styesheet via code. The <link> statement below (line #8) is how it is set. The code that sets is is shown at line #23.On my main form, I had to add the runat=server tag on the <head> in order to get my Ajax Editor control to work. When I add runat=server, the stylesheet no longer gets set. When I look at the source, the "<%" is changed to "<%" (line #8 below). I assume this is why my stylesheet is not being set. When I hard code the stylesheet (line #9), it works fine. How do I repair this?
[Code]....
use a stylesheet to reset css while using asp.net webform? I mean contrary to the asp.net MVC, which uses pure HTML and doesn't rely on some magic hidden elements somewhere.
View 1 RepliesMy company has new customers in Brazil and we realized that our excel reports are not working when our Brazilian customers tried to open the reports in their Brazilian versions of excel.
For excel output we use spreadsheet gear in our vb.net web application. Our excel worksheets are fairly simple. Mostly outputted text/numbers/dates, a couple of formulas (sum, if) and formatting on the currency and dates.
I've tried several methods to get my excel reports to work: First I left the excel workbook in the "en-US" culture and tried simply chaging the number format for Brazil to:
_-[$R$-416] * #.##0,00_-;-[$R$-416] * #.##0,00_-;_-[$R$-416] * "-"??_-;_-@_-
And this formatted the regular cells but the formulas still failed to show a value. Instead they showed a 0 value.
Next I tried changing the workbook to the "pt-BR" culture and that also forced me to translate the formula names (Sum -> Soma, If -> Se) but they still wouldn't should a value and instead showed a #Name/#Nome error. Interestingly enough the formulas would work if I edited the cell and hit enter. The formula wouldn't change but it would some how fix that cell.
I need to be able to out excel reports that can format dates/currencies and apply simple formulas (IF, Sum) for other excel cultures.
I would like to access an Excel 2010 spreadsheet via ASP.NET 4 - what is the best (i.e. straight forward) method to do this? I would like to update the spreadsheet via ASP then read the results of the data from Excel back to a web form.
View 9 RepliesI have a gridvidew (GV2). I want the user to be able to export the contents of this gridview to an excel spreadsheet for offline processing.
Here is my subroutine:
[code]...
On clicking the ExcelButton I get the error message:
Control 'GV2' of type 'GridView' must be placed inside a form tag with runat=server.
The control GV2 is in fact inside:
<form id="form1" runat="server"></form>
I would like to be able to copy one row and five columns from an Excel spreadsheet to a table like structure on a ASP.NET web form. The idea is keeping the data in the exact row and column from Excel to the table like control on the ASP.NET web-form. Then I want to be able to save to the contents of the ASP.NET control to a database by a buttoon command click. What ASP.NET control would allow me to do this? Gridviews and datagrids don't seem to allow me to do this.
View 1 RepliesMy host does not allow me to save files to the file system, but I would like to be able to send some reports via email as Excel attachments.
How can I generate and the file without actually saving it to disk?
I want to show information from an excel spreadsheet in a web page. The xls will have maybe 5 columns, and as many rows as needed. The columns will be 'Name', 'Created Date', 'Expired Date', 'Owner', and maybe down the road maybe more.
What I would like is for the C# to nightly read the xls, and display the information in a table on the website.
If there is a PDF available for download I am going to link that as well.
I have to import the contents of a spreadsheet in my asp.net project. The code behind is c#. how to locate the spreadsheet on the user's computer and how to import the data from a given worksheet into a datable. The problem is I may not know the name of the worksheet ahead of time. How do I present the user with a list of available worksheets and have them pick one?
View 2 RepliesI've tried many combonations and looked over may websites for sample code but no matter what I do I only getting a few cells of data from my Excel DataSet.
CODE:
using System;
i have a unordered list(HTML) whose style i am changing conditionally in the code behind
<ul class="steps">
<li class="" id="step1" runat="server">Step 1</li>
<li class="step2" id="step2" runat="server">Step 2</li>
<li class="step3" id="step3" runat="server">Step 3</li>
<li class="step4" id="step4" runat="server">Step 4</li>
</ul>
in the code behind iam doing something
step1.Attributes["class"] = "step1";
step2.Attributes["class"] = "step2New";
something like this
If iam using internal styles then its working fine but when iam taking the same style sheet to external file then it is not working
Is it because i am assigning attributes using id i don't know
the css file is some what like this
[Code]....
