Here's what I want to do, however I'm not sure of the best place for Excel. Excel files are sent via e-mail from various sources, from each source, they are sent in different versions of Excel and different information layouts, though from each source they are consistent.
Overview.
I want to give the user a front end to enable them to place the excel files into a drop zone and specify which files have come from which source. I then want to pass the file names and source origin to a workflow service. Based on this info the workflow service will then take 1..n workflow routes based on the source with the ultimate aim that data will be placed into an SQLServer 2005 DB or if the Excel lines cannot be processed, then output for the user to see with a reason. Because this is quite a complex task, I'm taking each source in turn.
Initial Problem.
My first set of Excel files come in 4 seperate files. I need to first merge the data in the Excel sheets to make 1 File for Processing. Some of the rows in the spreadsheets can be merged into a single line under certain conditions which will make the business logic much easier further on. So, first off After the user has dropped the Excel files into the drop zone I need to open the spreadsheets and merge them. I then need to feed each line to a 'rules' engine to determine the data and business logic that needs to be processed before updating the DB. So I thought I'd use a Workflow service for this since there will be no reason not to work on multiple sources at the same time as I progress through the development of the program. The problem I have is that unless I download the CP1 for workflow I cannot use this directly (so it appears) for working with Excel. So I was looking at using possibly WCF as the 'feed' to the workflow service, but can I use WCF to do the possible long running process of merging the Excel spreadsheets before pasing a row at a time down to the workflow service?
My web application currently requires users to upload files, after which I take it for "further processing". This processing is VERY time consuming and can take a while before the control gets back to the user. I would like to run this in the background and not have the user wait until this completes.
I know this question has been asked in this very forum before but I'm not able to understand or I'm not able to proceed in the right direction. My understanding is there are a few ways I can go about this
a) create a BackgroundWorker process in my Global.asax file that will spawn a process and take care of the activity.
b) create a web service that will do the processing for me .. (how?)
What are WebResource.axd and ScriptResource.axd ? Because more than 40% of my bandwidth use by those script loading and it take a long time to load the web site.
I'm populating a generic list from an excel file that contains names of pdf files. Now I want to take each item in the list and create a file from it. Here's what I have so far:
[Code]....
So now, the list called lines contains names of 900 pdf files. How would I take those names out of the list and create files from them?
I have a requirement like i have bulk of excel data which i have do validate and if it is okay then i need to insert the data in the DB .
Validations includes like datatype, length, precision.. etc ... Wil ahve thousands of records.
Earlier validation was done in the Stored procedure side where the developer moved the data to the temp table and loop through each row and validate it . But we are acing performace isues and some time time out error as well.
So i thought of silution like , Convert the execl data to datattable and validate the data in UI instead of the DB.
I'm using .net 3.5 and am currently creating a web application used to generate a report through Aspose.CellsActually, the page is composed in a form where I get the configuration of the report I have to generate. The "generation" button is in an update panel. When I click on it, the "generation" button is hidden and a progress bar appears. When the excel file is generated, I save it in a memory stream and I send it back to the aspx page where I change the headers to allow the file's download.
We are storing the WAV file into a database table as VARBINARY(MAX). We want to play the WAV file directly in a web page. We want to use PLAY, PAUSE and STOP for these WAV files.
We want the user to have a Control on the page to play the WAV file.
Here we DO NOT want to store the FILE in the Web Server's file structure. It is againt the SECURITY policy.
We tried different ways. Nothing is working. We used SoundPlayer class. Using this, we can only PLAY and STOP but can not PAUSE the WAV file.
I am building a command line application and I need to transform data within my application's classes to text.
It would make my life easy if I could use ASPX files to render my data into the target text format.
To achieve that, I need to be able to render an aspx file outside IIS. The following article explains how:
[URL]
The article is developed in 2003.
Is there any better way to so achieve similar result in .NET 4.0? Does MVC make this easier? Is this very memory/performance intensive? I have to create a new ApplicationHost anytime my command line application is executed. Is this approach reliable enough to be used in an environment with high throughput?
I have two projects (Project A and Project B), these projects are hosted in different locations and on different servers. Project B want to access the files of Project A. which technique is required to fulfill my requirements.
my subprojects creates serveral web.config files? I have solution that consists of 10 projects and I want everyone to compalie but the one in the top root. Now my problem is that my subprojects are all located inside folders in the root and my subprojects generates each a web.config. Thhis doesnät work very good so what should I reconfigure would you say?
We need to download multiple files from remote servers. It is a process that would take few hours to complete, since we are talking about images ~50kb each and more than 250.000 in total. Each images will downloaded, resized and then imported to SQL.DB, so we do not need to write files to the disk. Also the applications need to use network credentials, since it is behind ISA.
From your experience, what is the best method to implement this? Should we use WebClient or HttpSockets? Should we use Async methods or Threads ? How can we implement for example 5 simultaneously download to achieve better speed, since we may getting files from many different servers at once?
I have a single project. and I have two folder in it. In the 1st folder I have a class named Class1 and in the 2nd folder I have a class named Class2. Can anyone tell me how I can access members of Class1 in Class2. I have tried by adding namespace in Class1 and Using that namespace in Class2. But it is giving error. It is easy to access classes or their members from App_Code folder. I don't want to put my classes in app_code folder.
I have been wrestling with web services technology/techniques for part of 2010 - learning how to reate/consume/deploy... I have also been experimenting with third party web controls from ComponentArt. In some of the samples from ComponentArt I observed that they use .asmx files locally to populate their custom data controls (datagrids, comboboxes, treeview controls...). What is interesting (and a little bit confusing to me) is that in the ComponentArt samples they reference the web services directly within their controls in the markup. My question is if this can be done normally with controls that ship with Visual Studio (any version -- I have em all 2005, 2008, 2010). I ask this question because from VS I only know to reference web services by right clicking on the project in the solution explorer to add a web reference.
Then in the property grid of a data control -- say a treeview control-- they reference the web service, and when the project is run -- the control is populated with data from the web service.
Do data controls from VS support this technique? My other question is if there is a benefit to using a web service as a datasource for a control and what is this benefit? What is the criteria for using a web service in this manner?
1. A piece of software running locally on my pc periodically uploads (approximately every three minutes) to my webserver an xml file comprised of six fields. The file size is < 1K. 1a. The file name is always the same. ie. filename.xml is uploaded. Three minutes later, filename.xml is uploaded again, this time with different contents. I have no control over renaming this file.
2. A chunk of code that parses the xml and inserts the six fields into a database
3. Deletes the xml file
4. Waits for the next xml file to appear in the folder
5. Goto 2.
The locally running software uploads the file without issue. So far, I'm able to parse the xml, do the database insert and delete the file manually by refreshing the browser window and subsequently running the code in the .cshtml file. What I'm having a hard time conceptualizing is what the best way is to set up an automated event/method that watches the folder and when a new file appears, write it to the db without user intervention. Also, where would I put this code? _AppStart? Do I need to start a FileSystemWatcher event on the server somehow? I'm kinda stumped as to how best to proceed.
One of my NUnit tests has to read in some values from config files. In my main application this process works perfectly well, however when I run the unit test, the code that reads in the values from the config files doesnt read anything in. Ive tried putting app.config in my unit test project (I even tried web.config) but nothing seems to work. Are there any special steps involved when reading from config files in an nunit test ?
I using the OpenXML library to take a datatable and paste it into a pre formatted excel file. This works fine.
The problem I have is there is a subtotal row at the top of the pre-formatted excel file, that is set to subtotal each column of this data (so there is a subtotal at the top of each column). When I open the excel file after it has been created, these values are all set to 0, they have not updated when the datatable was inserted. If you highlight one of these subtotal cells and then press enter, it updates and shows the right value.
What is the easiest way to get these values to update and show the correct value as soon as the user opens the downloaded spreadsheet?
I'd like to know which are the best practise to easily manipulate excel files.I need to do only simple actions: create new file, add new sheets, populate cells from a dataset and add calculate cell.Is there something build-in visual studio or have I to use some third part tools?
I am having problems in manipulating excel files in vs2005. All I want is to get the excel files(this excel has specific design for reporting and has macros in it), read it, add data for reporting purpose, and make that file send to the client. Now, the problems I encountered and will encounter is:
1. It has password protect, I dont know how to unprotect it. I already use sheet.Unprotect("password here") but no use.
2. Actually I cant read this using Microsoft.Interop method.
3. Call every sheets I want to be updated.
4. Update the cells with data from database(getting database data is easy of course)
i'm trying to read an excel file and get data on a row by row basis. Since after converting the pdf file into an excel file, the formatting went a bit haywire but if read row by row, i'm still able to retrieve the original data.
As I am unable to generate the excel file using a single worksheet, i have multiple sheets in the excel file. I also need help on reading multiple sheets.
Currently i am onli able to get data via columns but due to the formatting going haywire, i gave up on it.
