Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

How to insert empty row Expand / Collapse
Author
Message
Posted Wednesday, September 12, 2012 10:45 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 13, 2015 5:21 AM
Points: 452, Visits: 1,073
Add a column named IgnoreThisRow, and set it to true for empty rows, false for real rows.



Post #1358120
Posted Wednesday, September 12, 2012 10:49 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 3:52 PM
Points: 377, Visits: 685
The site is used by over 100,000 users. Version of Excel cannot change.
Post #1358123
Posted Wednesday, September 12, 2012 1:47 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:35 PM
Points: 14,077, Visits: 13,695
ramadesai108 (9/12/2012)
The site is used by over 100,000 users. Version of Excel cannot change.


There seems to be something fundamentally poorly designed given all the challenges you are facing here. You have a web site with over 100,000 users all locked into a specific version of Excel? You are asking for problems with that.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1358196
Posted Wednesday, September 12, 2012 2:04 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, February 14, 2014 8:14 PM
Points: 32, Visits: 184
How are you generating this excel? via SQL? and getting it by file path to the web? what error are you seeing, exactly ? If you can manage to input lines with 0, can't you input lines with a single space?
I think we need more info on your problem
Post #1358200
Posted Friday, September 14, 2012 10:59 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 3:52 PM
Points: 377, Visits: 685
Using .Net app to connect to sql and get the data using store proc, creating excel file in the app and opening the file. There are no problems with this process. It is just that when the excel file that is produced is small size, excel does not open the file. This is a known issue and the workaround is to create empty rows in excel so that it increases the file and opens the file without any issues.
Post #1359514
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse