[RESOLVED] Show users Excel file template/sample

[MMock]

Hi, an easy question for a change. My users are giving me an excel file to import. I expect certain things in certain columns that they always get mixed up. What is the best way to have the code present a sample file or template that they must adhere to? I recall doing this a long time ago at another job. But when I googled it, I couldn't find anything like how I had done it, or how I wanted to do it. Thanks.

[Delaney]

Hello,

You could create a template (.xltx) that you protect by a password so they can just fill it and not modify it. You call it with your application and they will have to save it with a new name and so the original template won't be destroyed

regards

[MMock]

If it's password protected and they can't modify it, how do they save it? Unless you are saying I would present the blank template, and they would fill in the columns? I don't know if they prefer creating an excel file. Then they can save that and reprocess it if something goes wrong. Right? Or save it to have an audit trail. I'll think about some more, though. Thanks.

[Delaney]

here is an example of protected worksheet

example.zip

you can only fill the 3 yellow cells and save the file. I didn't put any password so you can remove the protection easily

[MMock]

@Delaney, thanks for the help. I ended up going with the DevExpress XtraSpreadsheet.SpreadsheetControl. We use DX controls throughout the application so I had this control readily available and it keeps the application consistent and does exactly what I wanted. https://docs.devexpress.com/WindowsF...es/spreadsheet