An implementation of functions for the creation of fake customer test data in Faker.NET (https://www.nuget.org/packages/Faker.Net) to Excel 2013 (as an XLL add-in) and later. Useful when customer production data is banned or inaccessible and the manual creation of customer data is too laborious.
This was updated for a presentation on creating test data and fuzzing at Australian Testing Days 2017, for which the slides can be found at - https://docs.google.com/presentation/d/1QpGhI0LUQslqSE-iO2DjbGb-3hxd5U8Mpf5kLmgi2RE/edit?usp=sharing.
- Download the package zip. Open and find the files -
FakerNETExcel-AddIn-packed.xll
FakerNETExcel-AddIn64-packed.xll
-
Open Excel 2013 or later. Create a new sheet.
-
Select File -> Options. In Excel Options, select "Add-Ins"
-
Next to the dropdown option "Manage", selected option "Excel Add-Ins", click "Go..."
-
In the Add-Ins popup, click Browse and open the XLL addin file above corresponding to your Excel installation.
-
Click the checkbox for the added file and then click ok.
-
Close the popup and in the sheet, select any cell. Search for or type in function starting with "Faker_"...
If a set of functions starting with "Faker_" exists, you have installed the add-in successfully.
The following Excel functions have been implemented in the current Faker.NET release. Others are being added as an ongoing effort.
- Faker_FirstName() - Returns a randomly selected First Name
- Faker_Surname() - Returns a randomly selected Surname
- Faker_Fullname() - Returns a randomly selected Full Name
- Faker_StreetAddress() - Returns a randomly selected Street Address
- Faker_StreetAddress(bool) - Returns a randomly selected StreetAddress. Pass parameter True if a secondary address to be returned.
- Faker_StreetSuffix() - Returns a randomly selected Street Suffix
- Faker_Country() - Returns a randomly selected Country
- Faker_AusTown() - Returns a randomly selected Australian town or city
- Faker_AusState() - Returns a randomly selected Australian state (full name)
- Faker_AusPostcode() - Returns a randomly created Australian postcode (defined as four random digits)
- Faker_AusPhoneNumber() - Returns a randomly created Australian phone/mobile number of various formats
- Faker_AusUniversity() - Returns a randomly created Australian university of various formats
- Faker_USState() - Returns a randomly selected US State.
- Faker_USStateAbbr() - Returns a randomly selected, abbreviated US State.
- Faker_USZipCode() - Returns a randomly selected US Zip Code.
- Faker_UKCounty() - Returns a randomly selected UK County.
- Faker_UKCountry() - Returns a randomly selected country in the UK.
- Faker_UKPostCode() - Returns a randomly selected UK Postcode.
- Faker_UKCompanyName() - Returns a randomly selected Company Name.
- Faker_UKCompanyCatchphrase() - Returns a randomly selected Company Catchphrase.
- Faker_Email() - Returns a randomly selected Email.
- Faker_Phone() - Returns a randomly selected (US Format) Phone.
- Faker_UserName() - Returns a randomly selected internet username.
- Faker_CreditCard() - Returns a credit card number. Enter in types VISA, MASTERCARD or DINERSCLUB. VISA is default.