RevitCity.com Logo

Home  |  Forums  |  Downloads  |  Gallery  |  News & Articles  |  Resources  |  Jobs  |  FAQ  |  SearchSearch  |  Join  |  LoginLogin

Welcome !

413 Users Online (213 Members): Show Users Online - Most ever was 626 - Mon, Jan 12, 2015 at 2:00:17 PM

 

Forums

Forums >> Revit Building >> Technical Support >> Exporting schedules to Excel with multiple lines in a cell

Search this ThreadSearch this Thread | Page 1 of 1 |

Thu, Jan 24, 2013 at 1:28:56 PM | Exporting schedules to Excel with multiple lines in a cell

#1

itavarescorreia


active

Joined: Tue, Nov 27, 2012
5 Posts
No Rating


Hi all, 

I am hoping someone can help me out. I am trying to fill out a room schedule with an additional parameter which lists all the inventory present in that room. This of course adds multiple lines to each row which I know how to do. However, when I link the .txt file back to Excel, what are paragraphs in RVT are merely spaces in excel, meaning that my multiple line cell is filled with a single line of loose words. 

Is there a way that I can export to txt and keep my paragraphs inside the parameter field? Or perhaps more adequately, is there a format that I need to apply in Excel? 

Thanks in advance! 


This user is offline

 

Thu, Jan 24, 2013 at 2:13:29 PM | Exporting schedules to Excel with multiple lines in a cell

#2

WWHub


site moderator|||

Joined: Tue, May 16, 2006
13079 Posts
3.5 Stars: 359 Votes


There is no such thing as a multi lined cell in Revit.  The cell just wraps (ONE CELL) - thats why it exports as it does.

Revit is always one line per "record".


This user is offline

 

Thu, Jan 24, 2013 at 2:19:09 PM | Exporting schedules to Excel with multiple lines in a cell

#3

itavarescorreia


active

Joined: Tue, Nov 27, 2012
5 Posts
No Rating


You can add multiple lines to a parameter by Ctrl+Enter, which is beneficial if you need to add additional information per paramenter (eg. Inventory). But Excel interprets them as a single line text. Is there a way around this? 


This user is offline

 

Thu, Jan 24, 2013 at 3:27:32 PM | Exporting schedules to Excel with multiple lines in a cell

#4

TKennedy


active

Joined: Wed, Oct 7, 2009
654 Posts
4 Stars: 7 Votes


You need to set Excel to wrap text in cells.


This user is offline

 

Thu, Jan 24, 2013 at 3:55:29 PM | Exporting schedules to Excel with multiple lines in a cell

#5

WWHub


site moderator|||

Joined: Tue, May 16, 2006
13079 Posts
3.5 Stars: 359 Votes


I know about the hard code word wrap in a Revit cell.  It is still one cell. As TKennedy says, you have to format the cell in Excel.


This user is offline

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

Exporting Multiple schedules to excel at once?

Revit Building >> Technical Support

Wed, May 21, 2008 at 3:11:07 PM

0

excel - autoCAD - revit

Revit Building >> Technical Support

Wed, Aug 7, 2013 at 9:37:34 PM

3

Exporting Electrical panel schedules to Excel

Revit Building >> Technical Support

Wed, Feb 18, 2009 at 8:53:31 PM

5

Exporting Schedules into excel format

General Discussion >> Revit Project Management

Fri, Mar 13, 2015 at 10:53:44 AM

3

exporting to excel

Revit Systems >> Technical Support

Mon, Feb 6, 2012 at 12:26:26 PM

3

Site Stats

Members:

1512337

Objects:

21254

Forum Posts:

151239

Job Listings:

3

Sponsored Ads

Home | Forums | Downloads | Gallery | News & Articles | Resources | Jobs | Search | Advertise | About RevitCity.com | Link To Us | Site Map | Member List | Firm List | Contact Us

Copyright 2003-2010 Pierced Media LC, a design company. All Rights Reserved.

Page generation time: 0.5133

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights