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 Tuesday, September 11, 2012 10:55 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 6:53 PM
Points: 3,374, Visits: 7,293
ramadesai108 (9/11/2012)
Cannot do that because that will require too many changes in the application.


Why? How are you populating your Excel file?
Are you sure this is the correct approach? I'm not sure that creating larger files is a good practice. Are you sure you can't change that in the options?

Another option would be use an older version of Excel to create the file



Luis C.
I am a great believer in luck, and I find the harder I work the more I have of it. Stephen Leacock

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1357586
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: Yesterday @ 5:21 AM
Points: 428, Visits: 928
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 @ 4:14 PM
Points: 13,126, Visits: 11,964
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
Posted Friday, September 14, 2012 12:54 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 2:44 PM
Points: 1,945, Visits: 2,862
What kind of concept is missing here? Why is it a problem to have a temp table with empty rows? It can be used to build Cartesian products [sic: cross JOIN], and it's quite easy to populate it, for example:


NULL is not empty and it is not zero. Totally different concepts.

There is an empty string ; it has length zero. But numeric and temporal data types (and all SQL data types) have a NULL. In RDBMS, ity has no data type, but in SQL we have to cast it for storage. Only in old version of Oracle, did NULL and empty strings act the same way. That is why they had to add VARCHAR2() to their products; it is the ANSI data type.

But tables are are made of rows, which are made of columns. They are at different levels in the conceptual structure. A table is not a value, so "empty table" is absurd.

C. J. Date has two relations (tables) in his version of RM. The table DUM has zero tuples (rows) of degree zero and DEE has one tuple (row) of degree zero.

They provide some identity relations with respect to JOIN. Joining any table to DEE returns the original table. Joining any table to DUM returns DUM. You can think of this as analogous to multiplying by 1 or 0.

Standard SQL does not have tuples (rows) of degree zero. So while it makes sense that relational theory includes these relations for completeness, SQL does not.


Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
Post #1359580
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse