Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel Templates for accounting use

Posted on 2010-11-24
16
Medium Priority
?
434 Views
Last Modified: 2012-06-27
How can Excel Templates for accounting use be created, displayed, and accessed by users?

Please provide samples and tutorials.

Thanks.
0
Comment
Question by:ksfok
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
  • 2
  • +2
16 Comments
 
LVL 21

Expert Comment

by:Alfred1
ID: 34210745
0
 
LVL 21

Accepted Solution

by:
Alfred1 earned 668 total points
ID: 34210758
Additional comment from my previous post, please note that the links in there are not working anymore.  It was working in the past.

You can try accessing office templates in the microsoft site.  I provided a link for a sales invoice as an example.

http://office.microsoft.com/en-gb/templates/CL102207654.aspx
0
 

Author Comment

by:ksfok
ID: 34233072
We can use the templates on an ASP.NET web site?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 6

Expert Comment

by:loopfinity
ID: 34254151
0
 

Author Comment

by:ksfok
ID: 34374431
Please provide sample sites.
0
 

Author Comment

by:ksfok
ID: 34504697
Please provide sample sites.
0
 

Author Comment

by:ksfok
ID: 34504700
Please do not delete the question.
0
 

Author Comment

by:ksfok
ID: 34504703
Please do not delete the question.
0
 
LVL 31

Expert Comment

by:hnasr
ID: 34506319
Can you comment on Alfred1 and and loopfinity comments?
How much helpful are they?
0
 
LVL 38

Assisted Solution

by:puppydogbuddy
puppydogbuddy earned 1332 total points
ID: 34506944
It appears that excel ss must be converted to xml before they can be used by a web server.
see this link:  http://www.eggheadcafe.com/software/aspnet/35410407/asp-net-25--vb--excel-2003--spreadsheet-population.aspx

Mark Rae [MVP] replied to Richard on Thursday, November 26, 2009 4:50 AM   Office Automation does not work in ASP.NET. Office was not designed to be used in this way, and Micrsoft does not support it:   http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2
Note specifically the "MORE INFORMATION" section and the paragraph in bold.
http://www.aspose.com/categories/.net-components/aspose.cells-for-.net/default.aspx 

Mark Stevens replied to Richard on Thursday, November 26, 2009 5:04 AM
Firstly, the method you have started to suggest (running Excel on the
web server) is not supported by MS as it can cause some issues.  In
fact there is an article on MSDN which warns against doing this.

Does this have to be Excel 2003 format?  I have used an Open XML
library from Codeplex (SimpleOOXML) to generate Excel 2007 files and
this works well.  Not tried named ranges but I do paste whole chunks
of data from a DataSet into a worksheet and that works fine.  Reason
for the question about Excel 2003 is that I have only worked with 2007
format with this library.
 
also see these links:
          http://forums.asp.net/t/1566458.aspx     (read all posts in this link)
          http://support.microsoft.com/kb/307033
          http://msdn.microsoft.com/en-us/library/aa701256(v=office.11).aspx
          http://support.microsoft.com/kb/319180
         
         
           
0
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 34507180
The commercial product at this link is worth looking into if you are sticking with asp.net:
                http://www.spreadsheetgear.com/support/samples/excel.aspx
0
 

Author Comment

by:ksfok
ID: 34674642
Is it free?
0
 
LVL 38

Assisted Solution

by:puppydogbuddy
puppydogbuddy earned 1332 total points
ID: 34675041
No. You can download a free 30 day evaulation copy, but it costs $999 to purchase a licensed version.   All license versions purchased include a perpetual license with royalty free client and server deployment, one year of updates and upgrades as well as one year of phone and email support.  See the following link:
                   https://www.spreadsheetgear.com/downloads/purchase.aspx
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When the s#!t hits the fan, you don’t have time to look up who’s on call, draft emails, call collaborators, or send text messages. An instant chat window is definitely the way to go, especially one like HipChat. HipChat is a true business app. An…
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question