Reading Xlsx When Cells Are In Hour Format?
Sep 27, 2010
I have a page that does an upload of an xlsx file to a datatable and write into SQL.
That is working, my problem is when i upload the file and pass the values to the datatable some of them are showing in the wrong format and the column name dont
appears.
e.g.:
Hours at home
Hours working
3:00
8:00
01-01-1900 1:35:00
01-01-1900 2:35:00
01-01-1900 3:35:00
The first 2 columns its how i want the info the third is how my problem looks like.
I've tested and the problem occurs when the same column has more than one value.
The format of the cells is h:mm if i change it to text it works fine but i dont want that because the time will be converted to semething like this 0,123456789.
I dont know if it matters but the xlsx file is kinda complex and has 10,2MB.
View 5 Replies
Similar Messages:
Jul 17, 2013
I have a form that contains a asp:Table and it contains 2 rows with 6 columns.
Also on my form is a gridview. It contains one row with 6 columns. (see pic)
I'd like to see if I can format both so that they appear to have the same over-all width and cell width too.
I'd like to know if it's possible to do this in the source view - rather than programmatically.
In the pic, the top is the grid view and underneath is the table.
View 6 Replies
Mar 13, 2012
in my web application page i have a option to export to excel . I am able to export the data to Excel but have 2 issues
1) i hav ethe option of exporting in .XLS or .XLSX format
i am able to export in .xls format from any system ie the system having office 2007 or 2003
but when i am trying to export in .XLSX format i get error
Microsoft Office Excel---------------------------The file you are trying to open, 'noup.xlsx', is in a different format than specified by the file extension. Verify that the file is not corrupted and that the file extension matches the file format---------------------------Ok---------------------------
2) when exporting i want the excel sheet to be saved with the name thats selected from a dropdown
suppose the dropdown has text selected as CITY
i want the excel sheet as CITY.XLS/.XLSX
i my developemnet system it works fine with below code
string filename = dropdown1.SelectedItem.Text
if (Extension.SelectedValue.ToString() == ".xls")
{
[Code].....
but on production server i get the name of .aspx page
View 1 Replies
Nov 16, 2010
I have requirement to show time in 24 hour format.
Right now code is like this
PorudctInfo.ReturnDate.ToString("yyyy-MM-ddThh:mm:ss").
Right now for eg return date time is "2010-11-17T01:15:00"
I want it in 24 hour format I should get it 13:15:00 format
View 2 Replies
Jan 28, 2010
I keep getting errors when I try to convert. I have a date row that when my page loads it displays as
1/28/2010 12:00:00 AM.
I have my default value set to '00:00:00" for it. I'm trying to convert it to 24 hour format so that it will read out as 00:00:00 initially. SQL Statement(The one that is working)
SELECT user_id, bpi_title, HoR, Date, Duration FROM tblViewLog2
JOIN tblBPIModules on tblViewLog2.module_id = tblBPIModules.id
I assume that I need to modify my SQL statement, but I'm having a hard time with the exact syntax. I'm trying to figure out exactly what I need to do with the information below in order to get what I want.
14 or 114
24 hour time with milliseconds.
HH:mm:ss:fff
21:00:00:000
View 2 Replies
May 7, 2015
I am using time picker control which you have created but I stuck in one issue. Iam using 24 hour format. but i its throwing in msg box standard hour instead of 24 hour format. How to get 24 hour format.
DateTime time = DateTime.Parse(string.Format("{0}:{1}", TimeSelector1.Hour, TimeSelector1.Minute));
lientScript.RegisterStartupScript(this.GetType(), "time", "alert('Selected Time: " + time.ToString("hh:mm") + "');", true);
View 1 Replies
Apr 13, 2010
My approach in reading a json format is parsing into an array. My question is this the right way of reading json format?
View 5 Replies
May 17, 2010
Excel cannot open the file "Report.xlsx" because the file format or extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file
View 2 Replies
Feb 26, 2011
I want to read data from an excel sheet which is in non-standard format. I have tried many things but could not find a solution,
View 1 Replies
Jun 3, 2010
I'm using a FCKEditor. I added some word document files in the server. I need to read the content of the work document in HTML format and assign it to the FCKEditor.
View 4 Replies
Dec 5, 2010
I am trying to import the excel file whose format is not in row column order in asp.net 3.5
I tried to read the file using OleDBDataAdapter but it given me the error "External file is not in proper format" something like that..
View 2 Replies
Mar 18, 2010
In my application, while reading body of mail. I am getting the text of the body as "This is a multipart message in MIME format."
Here is my code
SmtPop.POP3Client pop = new SmtPop.POP3Client();
pop.Open(serverName, 110, emailId, passWord);
SmtPop.POPMessageId[] messages = pop.GetMailList();
if (messages == null) return;
foreach (SmtPop.POPMessageId id in messages) {
try { Byte[] b = new Byte[0];
SmtPop.POPReader reader = pop.GetMailReader(id);
SmtPop.MimeMessage msg = new SmtPop.MimeMessage();
msg.Read(reader); Boolean kasbook=false;
String caseCode =null; string body = msg.Body; // read message
Regex rx = new Regex(@"(d{6}?)",RegexOptions.IgnoreCase);
MatchCollection matches = rx.Matches(msg.Subject);
if(matches.Count > 0) caseCode=matches[0].Value;
kasbook = Regex.IsMatch(msg.Subject,@"(kas)",RegexOptions.IgnoreCase);
if (msg.Attachments == null) continue;
Why I am not able to read the body of the mail.
View 8 Replies
Mar 7, 2011
I know this is probably a pretty easy thing to do and it is if I can upload the file and store it onto the hard drive of the server. What I need to do is read the text file into memory and then parse through it one line at a time. Anyone have any code that demonstrates that?
View 8 Replies
Aug 13, 2010
I had a friend ask me about writing a program that would allow data entry and then run and display a report each day at 11:00 am. What is the best/easiest way to make the report run at a specified hour? He wants something that can run on a standalone (laptop) computer running windows xp. Most of my experience is with asp.net and c#.
View 4 Replies
Jan 6, 2010
i would like to add one hour to this two dates bellow:
DateTime sd = DateTime.Parse(calendar.m_Start.ToString());
DateTime ed = DateTime.Parse(calendar.m_End.ToString());
string strSD = sd.ToString("dd. MMM HH:mm", System.Globalization.CultureInfo.CreateSpecificCulture("oo-OO"));
string strED = ed.ToString("dd. MMM HH:mm", System.Globalization.CultureInfo.CreateSpecificCulture("oo-OO"));
They are output here:
Response.Write(" <start_time>" + Server.HtmlEncode(strSD) + "</start_time>" + Environment.NewLine);
Response.Write(" <end_time>" + Server.HtmlEncode(strED) + "</end_time>" + Environment.NewLine);
View 3 Replies
Jan 1, 2013
I am developing an intranet web application. i am using asp.net,C# and MS sql. Now i want to make everyone hour to bring a grid view page with lists of names whose contractperiod is expiring soon. So how do I make an asp.net page to be pop up every hour.
View 2 Replies
Oct 28, 2010
I would like to export the data from GridView to Excel 2007 format XLSX.
View 27 Replies
Jan 17, 2011
I am unable to import xlsx file in Asp .Net getting below error:-
Could not find installable ISAM.
I am using below code for importing xlsx file:-
'function
Protected Function ExcelConnection() As OleDbCommand
' Connect to the Excel Spreadsheet
Dim xConnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:Users cs0028DesktopUpload1.xlsx;" & _
"Extended Properties=Excel 12.0;"
' create your excel connection object using the connection string
Dim objXConn As New OleDbConnection(xConnStr)
objXConn.Open()
Dim objCommand As New OleDbCommand("SELECT * FROM [Sheet1$]", objXConn)
Return objCommand
View 3 Replies
Sep 6, 2010
i want to change the hour that i get from date.now because the server is in different country and we have 2 hours difference.
View 19 Replies
Apr 22, 2010
I want to increase the session time,By default the session will expire in 20 minutes,I want that session will expire in 1 Hour,Hw to to dat?
View 11 Replies
Aug 12, 2010
Is it possible to have a thread running "for ever"? even when the browser is closed?
I tried this in my global.asax:
[Code]....
But without result. It works for about 20 seconds and then it stops until a new user opens a page.
View 5 Replies
Jan 22, 2011
var LateChangesTodate = (from lt in entities.Histories
where lt.RequestDate < dt && (lt.EmailDateA != null ? lt.CompleteDate.Value.AddHours(-48) > lt.EmailDateA : lt.CompleteDate.Value.AddHours(-48) > lt.RequestDate)
[code]...
View 5 Replies
Dec 30, 2010
i have used the Created_Date = DateTime.Now, to set the default value of a datebut i want that date to include inaddtion to the day the hour minutes and seconds
View 6 Replies
Oct 5, 2010
[Code]....
How to convert days into hours?
View 4 Replies
May 7, 2015
I want to call a function on every after one hour. I wrote this function in Global.asax file on Aplication_Start event. Its work fine in Local Host but not working after publishing it on web server.here is my code:
protected void Application_Start(object sender, EventArgs e)
{
Application["UsersOnline"] = 0;
[code]....
View 1 Replies
