Andrew Mac Posted December 15, 2008 Share Posted December 15, 2008 I have created my own excel file finish schedule- Is it possible to import this file into VW? If so can I can import it as an excel or do I need to import it as something else Quote Link to comment
Ray Libby Posted December 15, 2008 Share Posted December 15, 2008 Do a search of the Techboard on "+import +excel" and you'll find a few threads on the subject. You can't import excel files, my method is to create a PDF in excel, then import. Quote Link to comment
panta rhei Posted December 15, 2008 Share Posted December 15, 2008 In short, no, Except as a PDF. Quote Link to comment
Andrew Mac Posted December 15, 2008 Author Share Posted December 15, 2008 Thanks Quote Link to comment
panta rhei Posted December 15, 2008 Share Posted December 15, 2008 In long: You can export the data as a text file. Then figure out how many rows and columns you have. Then set up a worksheet. Then import the dumb data. Then format it. Unlike similar importing facilities by 3rd party developers, the standard issue "Import Workheet" can't even figure out the dimensions of the table. Not that any formatting or features would ever be achievable. But I think I'll continue this rant elsewhere and broaden the subject to overall ODBC connectivity once again. (Open Database Connecivity. Excel can do that. FileMaker Pro and Access can do that. VW cannot, because it is not "our focus". Quote - unquote.) So, all in all, I would recommend rebuilding your scheduling system in VW. You may even be positively surprised: you can link the schedule to Space objects. Quote Link to comment
bonus Posted December 15, 2008 Share Posted December 15, 2008 There is actually a way to do it - but it will only result in a "non-intelligent" (but editable) print in your drawing. Text and lines only. I'm not sure it works on PC though. Just open the excel worksheet you want to import. Select all. Copy all. Paste it where you want it in your vwx file. You may need to change text sizes etc to make it fit in the grids, but at least you have a presentation of the worksheet - if that's all you need. Quote Link to comment
Jeffrey W Ouellette Posted December 15, 2008 Share Posted December 15, 2008 Andrew, While you can't import an Excel spreadsheet directly, you can import the information of an Excel worksheet. As Ray and Petri noted, PDF gets you the Excel spreadsheet, as laid out in Excel, but it is not editable. Or, you could import the data of the spreadsheet and be able to edit the fields. First, export (Save As...) the spreadsheet from Excel in one of the following formats: comma delimited (aka, CSV), tab delimited, DIF or SYLK; Second, in VW, create a new worksheet in the Resource Browser (the default setting are fine, as the import will resize the worksheet, as needed) and open it; Next, select the Menu Bar command "File > Import > Import Worksheet..." and pick the desired file. Click "Open". BANG! You got Excel into VW. You can now graphically format it as you wish. Please note that the Excel formulas are not imported in the VW Worksheet, the Excel export just kicks out the final values in the respective cells, not the formulas. You'll have to rebuild the formulas, in necessary, in VW. Quote Link to comment
panta rhei Posted December 15, 2008 Share Posted December 15, 2008 Jeffrey, 1. Aren't you obfuscating things? 2. Does BANG! work? In the past, it certainly did not. 3. When rebuilding formulae, one needs, if effect, rebuild the logic. 4. By forgetting Excel, one can really excel. Quote Link to comment
Jeffrey W Ouellette Posted December 15, 2008 Share Posted December 15, 2008 I just tried it in VW 2008 SP3, Petri and it works. As I clarified, the formulas don't make it. I know it isn't exactly the same, but agree that the user should explore the power of the VW worksheet/database, when possible. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.