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.
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
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
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));
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
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.
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?
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#.
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.
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
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
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:
